34,587
社区成员
发帖
与我相关
我的任务
分享
declare @aaa int;
case when 1 then
select top 1 @aaa = aaa from Table_1 where def='0'
else
set @aaa=99 end;
declare @aaa int;
select
@aaa=
case when 1=1
then (select top 1 aaa from Table_1 where def='0')
else 99
end;