取出exec（）执行的结果表

http://www.cnblogs.com/yansheng9988/archive/2008/03/06/1094099.html

ALTER PROCEDURE [dbo].[Test] ASDECLARE @show_num varchar(9);Declare @abc nvarchar(200)BEGIN-- 方法一set @abc = 'select count(*) from users';exec ('declare mycur cursor for ' + @abc)open mycur;fetch next from mycur into @show_num;close mycur; select @show_num;-- 方法二 set @abc = 'select @a = count(*) from users';exec sp_executesql @abc,N'@a int output',@show_num outputprint（@show_num）; --方法3Insert #TempTable Exec(SQLScript)select #TempTable

可以将存储过程的返回结果赋值给临时表，

首先创建临时表:create table #temp(f1 int,...)

将存储过的结果插入到临时表:

insert into #temp1 execute sp_getsomething @para1, @para2