在存储过程中
DECLARE @SQL VARCHAR(5000)
DECLARE @SQL2 VARCHAR(5000)
set @sql='user_id=123'
select * from tab_user where +@sql --这儿怎么写才是正确的.注意不能用set @sq2='select * from tab_user where '+@sql+''
DECLARE @SQL VARCHAR(5000)
DECLARE @SQL2 VARCHAR(5000)
set @sql='user_id=123'
select * from tab_user where +@sql --这儿怎么写才是正确的.注意不能用set @sq2='select * from tab_user where '+@sql+''
exec('select * from tab_user where '+@sql)
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)
[/code]
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(N'select * from tab_user where 1=1' +@sql)
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)
@anction 已申明,为什么还是会提示没有申明
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)
(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 ,补充.