--try toSET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
set ANSI_WARNINGS on
go
CREATE PROCEDURE d_cyjs
@blh varchar(20),@fyzje numeric(10,2) output
as
Select @fyzje=fyzje from openrowset('sqloledb','server';sa;'pass',
'Select * from gm.dbo.table') as a
---下面略
go
GO
SET ANSI_NULLS ON
GO
set ANSI_WARNINGS on
go
CREATE PROCEDURE d_cyjs
@blh varchar(20),@fyzje numeric(10,2) output
as
Select @fyzje=fyzje from openrowset('sqloledb','server';sa;'pass',
'Select * from gm.dbo.table') as a
---下面略
go
SET ANSI_WARNINGS ON
GO
CREATE PROCEDURE d_cyjs @blh varchar(20),@fyzje numeric(10,2) output
as
select @fyzje=fyzje from openrowset('sqloledb','server';sa;'pass',gm.dbo.table)
---下面略
GO