ALTER view [dbo].[日报_接触明细]
as
SELECT * FROM
OPENROWSET('SQLOLEDB','server=.;uid=sa;pwd=sdty-cc','exec DBMobileBJ.dbo.Do_CallProcess_Jcmx_Report ')
GO
as
SELECT * FROM
OPENROWSET('SQLOLEDB','server=.;uid=sa;pwd=sdty-cc','exec DBMobileBJ.dbo.Do_CallProcess_Jcmx_Report ')
GO
改为
ALTER view [dbo].[日报_接触明细]
as
SELECT * FROM
OPENROWSET('SQLOLEDB','server=.;uid=sa;pwd=sdty-cc','SET FMTONLY OFF; SET NOCOUNT ON; exec DBMobileBJ.dbo.Do_CallProcess_Jcmx_Report ')
GO
加上 SET FMTONLY OFF; SET NOCOUNT ON;