declare @sqlstr varchar(4000) set @sqlstr='select top '+rtrim(@temp)+' GoodRecordNumber from tb_GoodRecord order by GoodRecordID desc' select @sqlstr='select * from ta where Good in '+@sqlstr exec(@sqlstr) @temp后面少了一个空格
roy_88(中国风_燃烧你的激情!!!) 你给的代码有错误啊
可以取出exec执行返回的值,形如: DECLARE @ParmDefinition nvarchar(50) SET @ParmDefinition = N'@TotalNumoutput int OUTPUT'; EXEC dbo.sp_executesql @strSQLAll,@ParmDefinition,@TotalNumoutput=@TotalNum OUTPUT;
set @sqlstr='select top '+rtrim(@temp)+' GoodRecordNumber from tb_GoodRecord order by GoodRecordID desc'
select @sqlstr='select * from ta where Good in '+@sqlstr
exec(@sqlstr)
@temp后面少了一个空格
你给的代码有错误啊
DECLARE @ParmDefinition nvarchar(50)
SET @ParmDefinition = N'@TotalNumoutput int OUTPUT';
EXEC dbo.sp_executesql @strSQLAll,@ParmDefinition,@TotalNumoutput=@TotalNum OUTPUT;