输出参数
eg:
declare @num,
@sqls
set @sqls='select count(*) from '+@servername+'.a.dbo.b'
exec(@sqls)
我如何能将exec执行的结果存入变量@num中declare @num int,
@sqls nvarchar(4000)
set @sqls='select @a=count(*) from '+@servername+'.a.dbo.b'
exec sp_executesql @sqls,N'@a int output',@num output
select @num
eg:
declare @num,
@sqls
set @sqls='select count(*) from '+@servername+'.a.dbo.b'
exec(@sqls)
我如何能将exec执行的结果存入变量@num中declare @num int,
@sqls nvarchar(4000)
set @sqls='select @a=count(*) from '+@servername+'.a.dbo.b'
exec sp_executesql @sqls,N'@a int output',@num output
select @num
exec sp_executesql @sqls,N'@a int output',@num outputN'@a int output'
是什么意思?
exec sp_executesql @sqls,N'@a int output',@num output,N'@b int output',@num2 output