当前位置: 代码迷 >> Sql Server >> Case的困惑?解决方法
  详细解决方案

Case的困惑?解决方法

热度:115   发布时间:2016-04-27 21:29:49.0
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 ....
  相关解决方案