Execute T-SQL using OpenRowSet 

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);Trusted_Connection=yes;',
     'EXEC TestTest.dbo.[getBusinessLineHistory]')

SELECT * FROM #MyTempTable
posted @ 2013-03-04 17:22  AOT  阅读(142)  评论(0)  编辑  收藏  举报