3.3w+
社区成员
declare @cond varchar(100)
declare @sql nvarchar(200)
declare @result int
set @cond = 'f_f1=''a'' and f_f2=''b'' and f_f3=''c'''
set @sql='select @id=id from basis_log where '+@cond
exec sp_executesql @sql,N'@id int output',@result output
select @result
declare @cond varchar(100)
set @cond = ' f_f1=''a'' and f_f2=''b'' and f_f3=''c'''
exec('select * from basis_log where '+@cond)
declare @cond varchar(100)
set @cond = 'f_f1=''a'' and f_f2=''b'' and f_f3=''c'''
declare @sql varchar(max)
set @sql = 'select * from basis_log where' + @cond
exec (@sql)