存储过程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 | |
![]() | ![]() |