Declare @temp varchar(100)select @temp='''temp1'',''temp2'''exec('select count(*) from table_name where field_name in ('+@temp+')')
Declare @temp varchar(100)select @temp='temp1'exec('select count(*) from table_name where (field_name in '+@temp)
Declare @temp varchar(100),@sql varchar(200)select @temp='''temp1'',''temp2''' set @sql='select count(*) from table_name where (field_name in (' + @temp + '))'exec (@sql)
where (field_name in '+@temp)
set @sql='select count(*) from table_name where (field_name in (' + @temp + '))'exec (@sql)