我在存儲過程中加入下面語句後會出現這樣的錯誤信息
Error information:
"Error 7405:Heterogeneous queries require the ANSI_NULLS and WARNINGS options to be set for the connection.This ensures consistent query semantics.Enable these options and then reissue your query."語句如下:
exec sp_addlinkedserver 'mm','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=nt03;UID=sa;PWD=topcomputer;'
insert into dd(dd_bh,dd_xt,dd_yscl,dd_chrq,dd_zss,dd_sl)
select b.ddmx_dh,c.ddxt_gcxt,b.ddmx_yscz,a.dd_wcrq,a.dd_slhj,sum(b.ddmx_sl)
from mm.eting.dbo.dd as a,mm.eting.dbo.ddmx as b,mm.eting.dbo.ddxt as c
where c.ddxt_xt=a.dd_xt
and a.dd_dh=b.ddmx_dh
and a.dd_dh not in(select dd_bh from dd)
group by b.ddmx_dh,c.ddxt_gcxt,b.ddmx_yscz,a.dd_wcrq,a.dd_slhj
order by b.ddmx_dh,c.ddxt_gcxt
end;
Error information:
"Error 7405:Heterogeneous queries require the ANSI_NULLS and WARNINGS options to be set for the connection.This ensures consistent query semantics.Enable these options and then reissue your query."語句如下:
exec sp_addlinkedserver 'mm','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=nt03;UID=sa;PWD=topcomputer;'
insert into dd(dd_bh,dd_xt,dd_yscl,dd_chrq,dd_zss,dd_sl)
select b.ddmx_dh,c.ddxt_gcxt,b.ddmx_yscz,a.dd_wcrq,a.dd_slhj,sum(b.ddmx_sl)
from mm.eting.dbo.dd as a,mm.eting.dbo.ddmx as b,mm.eting.dbo.ddxt as c
where c.ddxt_xt=a.dd_xt
and a.dd_dh=b.ddmx_dh
and a.dd_dh not in(select dd_bh from dd)
group by b.ddmx_dh,c.ddxt_gcxt,b.ddmx_yscz,a.dd_wcrq,a.dd_slhj
order by b.ddmx_dh,c.ddxt_gcxt
end;
解决方案 »
- 安装控件编译错误,Duplicate....inacessible from C++
- 怎样使formular one单元格处理可编辑状态?我想用双击单元格的形式修改单元格的内容,该怎么办呢?
- 求教:在DElphi中 通过程序开启和关闭windows2000/XP中的服务
- 关于Package(bpl)的动态调用问题。
- access中的date类型如何才能与delphi中的Tdatetime类型匹配
- 如何知道字符串1是否包含字符串2?
- cxGrid画线问题
- diamond ado 1.8安装失败。居然会拷贝文件失败。。:-(
- 来吧,写万能打印的同行,让我看看你的代码。
- update table set string_field=string_field+'my home' 出现错误?
- 初来报到﹐卻看到这些贴﹐决定远离这里。因为是对我们的入门者的侮辱。
- ClientSocket & ServerSocket的问题
exec sp_addlinkedserver 'mm','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=nt03;UID=sa;PWD=topcomputer;'
这些东西,去掉