Case的困惑?解决方法

Case的困惑??Case@sUserTypeWhengagantthenprintaElseprintbEnd[解决办法]Declare @sql varchar(8000)Sele

Case的困惑??
Case   @sUserType
When   'gagant '   then   print   'a '
Else   print   'b '
End

[解决办法]
Declare @sql varchar(8000)
Select @sql=Case @sUserType
when 'gagant ' then 'insert into gagant... '
when 'agant ' then 'insert into agant... '
else 'insert into user... ' end

exec(@sql)
[解决办法]
晕,
insert into agant (col)
select
(case @sUserType when 'gagant ' then ...
case @sUserType when 'agant ' then ...
else ...
end) from tb where ....