Category: MERGE

• Merge Wonders – Insert or Use

  

  2013-02-05 - General, Hints, MERGE, Performance, T-SQL Statements

  One of the most often encountered concurrency problems in T-SQL code happens in the Insert or Use scenario in which a new row is inserted if it does not exist yet and afterwards the primary key of the existing or the new row is returned. One of the easiest and safest ways to get this right is provided by the MERGE statement.

  [more…]