MERGE is a new operation added in SQL Server 2008. It has all sorts of knobs, bells, and whistles.
Excerpt from:
Conor vs. MERGE and PRIMARY KEY collisions
MERGE is a new operation added in SQL Server 2008. It has all sorts of knobs, bells, and whistles.
Excerpt from:
Conor vs. MERGE and PRIMARY KEY collisions