如何将exec执行结果放入变量中

--如何将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

原文地址:https://www.cnblogs.com/martian6125/p/9631187.html