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);
SqlServer实现Mysql的replace
最新推荐文章于 2024-03-09 19:21:40 发布
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);