http://www.cnblogs.com/yansheng9988/archive/2008/03/06/1094099.html
ALTER PROCEDURE [dbo].[Test]
AS
DECLARE @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 output
print(@show_num);
--方法3
Insert #TempTable Exec(SQLScript)
select #TempTable
可以将存储过程的返回结果赋值给临时表,
首先创建临时表:create table #temp(f1 int,...)
将存储过的结果插入到临时表:
insert into #temp1 execute sp_getsomething @para1, @para2