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 ....
