Merge into [tableName] as t Using(select [@id] as tid) as t1 on t1.tid=t.id when matched then update set name=‘name1‘ when not matched then insert(name) values(‘name‘);
Sqlserver添加或更新数据SQL
原文：http://www.cnblogs.com/xyzhuzhou/p/5834275.html
