goback add

存储过程A里,将存储过程B的结果集存到A的临时表或者表变量里

3244 点击·0 回帖
灯火互联
楼主
存储过程A里,将存储过程B的结果集存到A的临时表或者表变量里
 
CREATE TABLE test1
(
  a VARCHAR(20)
)
GO
CREATE TABLE test2
(
  a VARCHAR(20)
)
GO
 
 
INSERT INTO test1 VALUES('aaa')
GO
 
 
CREATE PROCEDURE sp_test
AS
SELECT * FROM test1
GO
 
 
EXEC sp_test
GO
 
 
INSERT INTO test2 EXEC('EXEC SP_TEST');
GO
 
 
SELECT * FROM test2
GO
 
sp_configure 'Show Advanced Options', 1
GO
RECONFIGURE
GO
sp_configure 'Ad Hoc Distributed Queries', 1
GO
RECONFIGURE
 
 
alter procedure sp_test2 as
SELECT *  
 
 
INTO #MyTable  --( can be either a temp table or perm table,不用事先知道其Schema,这正是你想要的)
 
 
FROM OPENROWSET('SQLNCLI', 'server=.;trusted_connection=yes',  
 
 
'exec IPSUNU9DB_20130425.dbo.SP_TEST')
select * from #MyTable
 
exec sp_test2

喜欢0 评分0