case给变量赋值

declare @d int ,@s char(20)
set @d=3
set @s=
case 
	when @d=1 then  'is adasdas'
	when @d=2 then  'is 2a'
	else
	'aaaaa'	

错误写法1

 set @ char  

这里的char 默认为char(1)
错误写法2

 case 
	when @d=1 then   'is adasdas'//then后面是一个变量，也就是case的返回值，所以他必须有返回值
	when @d=2 then  'is 2a'
	else
	'aaaaa'	
end