Ce site est optimisé pour être consulté depuis un navigateur moderne dans lequel JavaScript est activé.

Insert results of a stored procedure into a temporary table

ayi

<t>Insert results of a stored procedure into a temporary table</t>

ayi

<t>You can use OPENROWSET for this. Have a look. I've also included the sp_configure code to enable Ad Hoc Distributed Queries, in case it isn't already enabled.<br/>
<br/>

CREATE PROC getBusinessLineHistory<br/>
AS<br/>
BEGIN<br/>
    SELECT * FROM sys.databases<br/>
END<br/>
GO<br/>
<br/>
sp_configure 'Show Advanced Options', 1<br/>
GO<br/>
RECONFIGURE<br/>
GO<br/>
sp_configure 'Ad Hoc Distributed Queries', 1<br/>
GO<br/>
RECONFIGURE<br/>
GO<br/>
<br/>
SELECT * INTO #MyTempTable FROM OPENROWSET('SQLNCLI', 'Server=(local)\SQL2008;Trusted_Connection=yes;',<br/>
     'EXEC getBusinessLineHistory')<br/>
<br/>
SELECT * FROM #MyTempTable<br/>
<br/>
```</t>