Create VIEW ViewRpVmsToken --创建视图
AS
SELECT *
FROM OPENROWSET(
'SQLNCLI', ---DBlink
'DRIVER={SQL Server};
SERVER=192.168.0.204;UID=sa;PWD=1;Trusted_Connection=no',
'SET FMTONLY OFF;SET NOCOUNT ON;EXEC QMNEW0618.dbo.proctest') --存储过程名称
GO
Create VIEW ViewRpVmsToken --创建视图
AS
SELECT *
FROM OPENROWSET(
'SQLNCLI', ---DBlink
'DRIVER={SQL Server};
SERVER=192.168.0.204;UID=sa;PWD=1;Trusted_Connection=no',
'SET FMTONLY OFF;SET NOCOUNT ON;EXEC QMNEW0618.dbo.proctest') --存储过程名称
GO