mssql merge has a lot of problems. it's good for the most basic and straightforw... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		swasheck on Sept 25, 2023 \| parent \| context \| favorite \| on: Upsert in SQL mssql merge has a lot of problems. it's good for the most basic and straightforward of use cases, but it struggles with a variety of features: https://michaeljswart.com/2021/08/what-to-avoid-if-you-want-...

mwigdahl on Sept 25, 2023 [–]

We stripped MERGE out of all of our production code. Not worth the many corner cases and footguns that remain even after over 15 years of being in the product.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact