declare @s varchar(200) set @s=22declare @sql varchar(8000) set @sql= 'select * from t1 where id in(' +@s+')' exec( @sql)
select * from t1 where id in('+@s+'))
你说的游标是什么意思? 是要这样? [code=SQL]declare @s nvarchar(100) set @s='124,274,335,477' declare @sql nvarchar(1000) set @sql='select * from t1 where id in('+ @s +')' exec(@sql)[code]
set @s=22declare @sql varchar(8000)
set @sql= 'select * from t1 where id in(' +@s+')'
exec( @sql)
是要这样?
[code=SQL]declare @s nvarchar(100)
set @s='124,274,335,477'
declare @sql nvarchar(1000)
set @sql='select * from t1 where id in('+ @s +')'
exec(@sql)[code]
set @i=5
exec('select ID,Name from sysobjects where ID='+@i)set @s='select ID,Name from sysobjects where ID=@i'
exec sp_executesql @s,N'@i int',@i--此处输入参数要加上N--方法4:输出参数declare @i int,@s nvarchar(1000)
set @s='select @i=count(1) from sysobjects'--用exec
exec('declare @i int '+@s+' select @i')--把整个语句用字符串加起来执行--用sp_executesql
exec sp_executesql @s,N'@i int output',@i output--此处输出参数要加上N
select @i
--方法5:输入输出--用sp_executesql
declare @i int,@con int,@s nvarchar(1000)
set @i=5
select @s='select @con=count(1) from sysobjects where ID>@i'
exec sp_executesql @s,N'@con int output,@i int',@con output ,@i
select @con--用exec
declare @i int,@s nvarchar(1000)
set @i=5
select @s='declare @con int select @con=count(1) from sysobjects where ID>'+rtrim(@i)+' select @con'
exec(@s)
select * from t1 where id in ('+@s+')