> use with a merge statement in order to get an atomic upsert - holdlock in sql server Because of all the potential edge cases that MERGE didn't handle properl

> use with a merge statement in order to get an atomic upsert - holdlock in sql server Because of all the potential edge cases that MERGE didn't handle properly when introduced to SQL Server (2008?), I've avoided its use. Despite several revisions over the years there are apparently still significant behaviours that I'd consider bugs¹, some of which have been closed as WONTFIX² so are a fact of life you just have to accept if you use MERGE in SQL Server. [1] see https://sqlsunday.com/2021/05/04/how-merge-can-deadlock-you/ https://sqlsunday.com/2021/05/04/how-merge-can-deadlock-you/ & https://michaeljswart.com/2021/08/what-to-avoid-if-you-want-to-use-merge/ https://michaeljswart.com/2021/08/what-to-avoid-if-you-want-... and many other similar articles [2] https://www.mssqltips.com/sqlservertip/3074/use-caution-with-sql-servers-merge-statement/ https://www.mssqltips.com/sqlservertip/3074/use-caution-with...