34,590
社区成员
发帖
与我相关
我的任务
分享
declare @str varchar(50)
select @str =
case when stname != '' then stname end
from stu s,stname sn
where s.st_id = sn.st_id
---应该是这样
select
(@stu=case when stname!='' then stname else 0 end )
from
stu s,stname sn
where
s.st_id=sn.st_id
select
@stu=case when stname!='' then stname else 0 end
from
stu s
where
st_id=1
select @stu=case when stname!='' then stname else xxx end
from stu as a where st_id=1