--如何将exec执行结果放入变量中?
declare @num int,@sqls nvarchar(4000)
set @sqls='select @a=count(*) from aa_busobject '
exec sp_executesql @sqls,N'@a int output',@num output
select @num
--如何将exec执行结果放入变量中?
declare @num int,@sqls nvarchar(4000)
set @sqls='select @a=count(*) from aa_busobject '
exec sp_executesql @sqls,N'@a int output',@num output
select @num