case循环例子

case...when...then语句例子：

 @szid预定义输入变量，@iReturn预定义输出变量

select @iReturn =              

(case              

when sms=0 then 3              

when sms=1 then 8              

when sms=2 then 7              

 end)              

from dbo.[表] where (userid=@szid and iscorp>2)