merge into TEST_TABLE as A
using
select INSURED,BAL from TEST_TABLE)B
on A.INSURED=B.INSURED
when matched then --条件匹配用update
update set A.BAL=B.BAL,UPDATEDATE=getutcdate()
when not matched then --条件不匹配用insert
insert (INSURED,BAL,CREATEDATE,UPDATEDATE) values (B.INSURED,B.BAL,getutcdate(),getutcdate())
sqlserver merge用法
于 2021-11-18 14:20:07 首次发布