--改为即可
if exists(select * from opendatasource('sqloledb','data source=218.9.73.233;user id=sa;password=').webjxc.dbo.wz_kc as web,wz_kc where web.rowguid=wz_kc.rowguid and web.数量<>wz_kc.数量)
begin
UPDATE opendatasource('sqloledb','data source=218.9.73.233;user id=sa;password=').webjxc.dbo.wz_kc
SET 数量 = b.数量
FROM opendatasource('sqloledb','data source=218.9.73.233;user id=sa;password=').webjxc.dbo.wz_kc a, wz_kc b
WHERE a.rowguid = b.rowguid
end
---------------只供参考。
if exists(select * from opendatasource('sqloledb','data source=218.9.73.233;user id=sa;password=').webjxc.dbo.wz_kc as web,wz_kc where web.rowguid=wz_kc.rowguid and web.数量<>wz_kc.数量)
begin
UPDATE opendatasource('sqloledb','data source=218.9.73.233;user id=sa;password=').webjxc.dbo.wz_kc
SET 数量 = b.数量
FROM opendatasource('sqloledb','data source=218.9.73.233;user id=sa;password=').webjxc.dbo.wz_kc a, wz_kc b
WHERE a.rowguid = b.rowguid
end
---------------只供参考。
use database1
go
update A
set
name = '胡军'
from server.database2.dbo.table2 A
where id = 100001
use database1
go
exec('update server.database2.dbo.table2
set
name = '''胡军'''
from server.database2.dbo.table2
where id = 100001')