1. 应用场景:如果存在就修改,如果不存在就插入。
merge Product as target
using (select 2 as ProductID) as source
on (target.ProductID=source.ProductID)
when matched then update set ProductName='更新的'
when not matched then insert(ProductID,ProductName)values(source.ProductID,'新增的');
2. 语法:
- MERGE 目标表
- USING 源表
- ON 匹配条件
- WHEN MATCHED THEN
- 语句
- WHEN NOT MATCHED THEN
- 语句;
- WHEN NOT MATCHED BY TARGET 目标表不匹配(默认)
- WHEN NOT MATCHED BY SOURCE 源表不匹配