--定义一个与存储过程返回数据集一致的临时表.类似如下: CREATE TABLE #(... )INSERT INTO # EXEC 存储过程
select * into newtable from Northwind.dbo.Employees select * from newtable
CREATE TABLE #(... )INSERT INTO # EXEC 存储过程create talbe temptable( ) go insert [into] temptable exec sp
--第一种方法:直接用存储过程返回的数据集select * from openrowset('sqloledb','Trusted_Connection=yes','exec 数据库名.dbo.存储过程名') select * from openrowset('sqloledb','Trusted_Connection=yes','exec 数据库名..存储过程名') select * from openrowset('sqloledb','localhost';'用户名';'密码','exec 数据库名..存储过程名')select * from openrowset('sqloledb','192.168.0.1';'用户名';'密码','exec 数据库名..存储过程名')-第二种方法:先创建临时表,然后再追加create table #t(...)insert into #t exec 存储过程名select * from #t
CREATE TABLE #(...
)INSERT INTO # EXEC 存储过程
select * from newtable
)INSERT INTO # EXEC 存储过程create talbe temptable(
)
go
insert [into] temptable
exec sp