34,590
社区成员
发帖
与我相关
我的任务
分享
exec('select
(case '+ @anction+' when 1 then corp_name when 2 then pro_name when 3 then staff_name end) AS name
from tab_user where '+@sql)
-->case前面要留空格.后面少了end ,补充.
exec('select
(case'+ @anction+' when 1 then corp_name when 2 then pro_name when 3 then staff_name ) AS name
from tab_user where '+@sql)
DECLARE @SQL VARCHAR(5000)
DECLARE @SQL2 VARCHAR(5000)
set @sql='user_id=123'
exec(N'select * from tab_user where 1=1' +@sql)
DECLARE @SQL VARCHAR(5000)
DECLARE @SQL2 VARCHAR(5000)
set @sql='user_id=123'
exec('select * from tab_user where '+ @sql)
DECLARE @SQL VARCHAR(5000)
DECLARE @SQL2 VARCHAR(5000)
set @sql='user_id=123'
exec('select * from tab_user where '+@sql)
exec('select * from tab_user where '+@sql)
exec('select * from tab_user where '+@sql)
EXEC('select * from tab_user where '+@SQL);