T SQL Upserts Merge

Use when writing or reviewing an upsert or MERGE for Azure SQL Database: insert or update, ON CONFLICT, lost writes or 2627 under load. Has verified behavior common answers miss, e.g. a bare MERGE loses writes under concurrency.

Microsoft Updated 195k repo stars

File contents

microsoft/microsoft-sql commit c9e98a62a5

Frequently asked questions

npx get-skill add microsoft/t-sql-upserts-merge