CREATE PROCEDURE aaa AS select * from openquery(server9,'select * from 数据库名..库存查询') go
to: pbsql(风云) 我就是只写了 CREATE PROCEDURE aaa AS select * from openquery(server9,'select * from 数据库名..库存查询') go 后报错的! 我加了 set ANSI_NULLS ON set ANSI_WARNINGS ON 还是报错
再试一下: set ANSI_NULLS ON set ANSI_WARNINGS ON go CREATE PROCEDURE aaa AS select * from openquery(server9,'select * from 数据库名..库存查询') --注意这里有库名 go
AS
select * from openquery(server9,'select * from 数据库名..库存查询')
go
我就是只写了
CREATE PROCEDURE aaa
AS
select * from openquery(server9,'select * from 数据库名..库存查询')
go
后报错的!
我加了
set ANSI_NULLS ON
set ANSI_WARNINGS ON
还是报错
set ANSI_NULLS ON
set ANSI_WARNINGS ON
go
CREATE PROCEDURE aaa
AS
select * from openquery(server9,'select * from 数据库名..库存查询') --注意这里有库名
go