34,872
社区成员
发帖
与我相关
我的任务
分享这是为什么？！！！
alter proc hkw
@com_id char(10) =null,
@com_name char(100)=null
AS
if @com_name is null
select total=sum(salary) from works where company_id=@com_id
else
select total=sum(a.salary) from works a,company b where b.company_name=@com_name and a.company_id=b.company_id
~~~~~~~~~~把这里改成like '%@com_name%',本来正确的结果，
现在结果变为NULL，有谁知道为什么吗？
order by total desc
go
exec hkw '','banka'
go
@com_id char(10) =null,
@com_name char(100)=null
AS
if @com_name is null
select total=sum(salary) from works where company_id=@com_id
else
select total=sum(a.salary) from works a,company b where b.company_name=@com_name and a.company_id=b.company_id
~~~~~~~~~~把这里改成like '%@com_name%',本来正确的结果，
现在结果变为NULL，有谁知道为什么吗？
order by total desc
go
exec hkw '','banka'
go
...全文
请发表友善的回复…
发表回复
huangkw007 2003-04-25
- 打赏
- 举报
一样的~~（：
SophiaWang 2003-04-25
- 打赏
- 举报
其实，
alter proc hkw
@com_id char(10) =null,
@com_name char(100)=null
AS
if @com_name is null
select total=sum(salary) from works where company_id=@com_id
else
exec('select total=sum(a.salary) from works a,company b where b.company_name like ''%'+rtrim(@com_name)+'%''and a.company_id=b.company_id order by total desc')
go
exec hkw '','banka'
go
也可以
alter proc hkw
@com_id char(10) =null,
@com_name char(100)=null
AS
if @com_name is null
select total=sum(salary) from works where company_id=@com_id
else
exec('select total=sum(a.salary) from works a,company b where b.company_name like ''%'+rtrim(@com_name)+'%''and a.company_id=b.company_id order by total desc')
go
exec hkw '','banka'
go
也可以
joygxd 2003-04-25
- 打赏
- 举报
那是个变量
SophiaWang 2003-04-25
- 打赏
- 举报
那我就来接分了，哈~~~
SophiaWang 2003-04-25
- 打赏
- 举报
好象你已经搞定了？？
huangkw007 2003-04-25
- 打赏
- 举报
明白了，刚才查了一下帮助要这样写
alter proc hkw
@com_id char(10) =null,
@com_name char(100)=null
AS
if @com_name is null
select total=sum(salary) from works where company_id=@com_id
else
begin
SELECT @com_name = '%'+RTRIM(@com_name) + '%'
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~`要这样写！
select total=sum(a.salary) from works a,company b where b.company_name like @com_name and a.company_id=b.company_id
order by total desc
end
go
exec hkw '','banka'
go
alter proc hkw
@com_id char(10) =null,
@com_name char(100)=null
AS
if @com_name is null
select total=sum(salary) from works where company_id=@com_id
else
begin
SELECT @com_name = '%'+RTRIM(@com_name) + '%'
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~`要这样写！
select total=sum(a.salary) from works a,company b where b.company_name like @com_name and a.company_id=b.company_id
order by total desc
end
go
exec hkw '','banka'
go
主要给大家介绍了关于对比Java，实例讲解Kotlin中?.与!!.的区别，文中通过示例代码介绍的非常详细，对大家学习或者使用kotlin具有一定参考学习价值，需要的朋友们下面随着小编来一起学习学习吧
