34,588
社区成员
发帖
与我相关
我的任务
分享
MERGE Replica AS R
USING original AS O ON r.PK=o.PK
WHEN matched AND (r.FName<>o.FName OR r.Number<>o.Number) THEN
UPDATE SET r.PK=o.PK,r.FName=o.PK,r.Number=o.Number
WHEN NOT matched BY TARGET THEN INSERT VALUES (o.PK,o.FName,o.Number)
WHEN NOT matched BY source THEN DELETE
insert into B
select * from A
where not exists
(select '1' from B
where B.nul1=A.nul1
and B.nul3=A.nul3
and B.nul4=A.nul4
)