sql server - How can I use SQL MERGE to upsert single row ...

2013年4月16日 - You can also use this syntax: merge into MyTable mt using (values (@myId, @myValue)) t(id, value) on mt.Id = t.id when not matched then insert /* ... */.

stackoverflow.com