--when you don’t know the structure that the store procedure generates:
CREATE TABLE ##1
(ID1 INT)
CREATE TABLE ##2
(ID1 INT
)
INSERT ##1
SELECT 1
CREATE PROC UP_TEST
AS
BEGIN
SELECT * FROM ##1
END
INSERT INTO ##2 EXEC UP_TEST
SELECT * FROM ##1
--otherwise:
SELECT * INTO #TEMP
FROM OPENROWSET('SQLOLEDB',
'SERVER=MISDBS01;UID=PAS;PWD=PAS;DATABASE=MASTER',
'EXEC SP_WHO') AS A
SELECT * FROM #TEMP
如果存储过程中用到临时表，要用SET FMTONLY OFF
SELECT * INTO #TEMP
FROM OPENROWSET('SQLOLEDB',
'SERVER=MISDBS01;UID=PAS;PWD=PAS;DATABASE=MASTER',
'SET FMTONLY OFF;EXEC SP_WHO') AS A
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。