视图 调用 存储过程 view call procedure in sqlserver 2008

在视图中使用 存储过程返回的数据集 例子

sqlserver2008

Create VIEW vwGetAtAGlanceReport              --创建视图
AS
SELECT *
FROM OPENROWSET(

'SQLNCLI',                 ---DBlink 
'DRIVER={SQL Server};

SERVER=192.168.0.13;

UID=sa;PWD=sa;

Trusted_Connection=no',
'SET FMTONLY OFF;

SET NOCOUNT ON;

EXEC PieroTest.dbo.SP_GetAtAGlanceReport') --存储过程名称

OPENROWSET 函数介绍

http://technet.microsoft.com/zh-cn/library/ms190312.aspx
来源：
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=123346

http://stackoverflow.com/questions/7826557/using-openrowset-to-dynamically-retrieve-sp-results-when-sp-contains-temp-tabl

 

 

ole Providers:

/*
ADsDSOObject
DTSPackageDSO
Microsoft.ACE.OLEDB.12.0
Microsoft.Jet.OLEDB.4.0
MSDAORA
MSDAOSP
MSDASQL
MSDMine
MSIDXS
MSOLAP
SQLNCLI10
SQLNCLI11
SQLOLEDB
SQLReplication.OLEDB
SQLXMLOLEDB
SQLXMLOLEDB.4.0
*/