True. Don't use MERGE in MS SQL Server. Use two separate statements. | Hacker News

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

		kardianos on Sept 4, 2020 \| parent \| context \| favorite \| on: Upsert anti-pattern in SQL Server True. Don't use MERGE in MS SQL Server. Use two separate statements.

teh_klev on Sept 4, 2020 [–]

It's better to back up assertions, even if you're correct:

By the same author (who I highly respect):

https://www.mssqltips.com/sqlservertip/3074/use-caution-with...

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