update B set 字段1=A.字段1 from A inner join B on A.id=B.id insert into B select * from A where checksum(*) not in (select checksum(*) from B)
继承ls的 create procedure pro_B as --先更新 update B set 字段1=A.字段1 from A inner join B on A.id=B.id --再插入 insert into B select * from A where checksum(*) not in (select checksum(*) from B) go
create proc sp_同步数据 as set xact_abort onbegin tranupdate B set 字段1=A.字段1 from A inner join B on A.id=B.id insert into B select * from A where checksum(*) not in (select checksum(*) from B)commit tranreturn 0
from A inner join B on A.id=B.id
insert into B
select *
from A
where checksum(*) not in (select checksum(*) from B)
create procedure pro_B
as
--先更新
update B set 字段1=A.字段1
from A inner join B on A.id=B.id
--再插入
insert into B
select *
from A
where checksum(*) not in (select checksum(*) from B)
go
as
set xact_abort onbegin tranupdate B set 字段1=A.字段1
from A inner join B on A.id=B.id
insert into B
select *
from A
where checksum(*) not in (select checksum(*) from B)commit tranreturn 0