Solutions for INSERT OR UPDATE on SQL Server - Stack Overflow

This answer really needs updated to account for the comment by Seph about it not being thread-safe without a HOLDLOCK. According to the linked post, MERGE implicitly takes out an update lock, but releases it before inserting rows, which can cause a race .

stackoverflow.com