数据库处理错误问题 急
miu 2002-04-23 01:23:58 我在SQL SERVER通过链接服务器调用ACCESS数据库的表
CREATE PROCEDURE dbo.tpics_dr AS
SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
delete from bjkc
insert into bjkc(scode ,ename,inventory.price) select tp.code as scode,tp.name as name,
tp.zaik as inventory,tp.ffree1 as price from tpics...item tp order by tp.code
存盘时系统出现如下错误:
heterogeneous queries reqiure the ANSI_NULLS and AUSI_WARNINGS options
to be set for the connection .This ensures consistent query semantics.
请各位帮忙查看代码为何已经增加了上面的两个SET语句还会出现这样错误