如何将存储过程的结果插入到临时表中

您可以使用OPENROWSET（https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008/ms190312(v=sql.100)?redirectedfrom=MSDN），我还提供了sp_configure代码

CREATE PROC getBusinessLineHistory 
AS 
BEGIN 
SELECT * FROM sys.databases 
END 
GO 

sp_configure 'Show Advanced Options', 1 
GO 
RECONFIGURE 
GO 
sp_configure 'Ad Hoc Distributed Queries', 1 
GO 
RECONFIGURE 
GO 

SELECT * INTO #MyTempTable FROM OPENROWSET('SQLNCLI', 'Server=(local)\SQL2008;Trusted_Connection=yes;', 'EXEC getBusinessLineHistory') 
SELECT * FROM #MyTempTable