MERGE is a new operation added in SQL Server 2008. It has all sorts of knobs, bells, and whistles.
Conor vs. MERGE and PRIMARY KEY collisions
Filed under: 2008, 2009, anonymous, application, cd, cli, cloud, community, data, drive, EFI, email, events, media, Microsoft Rules, news, photo, play, press, Q1, screen, script, search, serial, server, source, tasks, themes, tip, tor, trends, ui, virtualization, windows