SqlServer实现Mysql的replace

Merge Into t_A As a Using t_B as b on a.id=b.id When Matched then update set a.SNO=b.SNO When Not Matched then Insert(id,SNO) values(b.id,b.SNO);