• Merge statement allows us to perform Inserts, Updates, and Deletes in one statement.
  • Requires two tables
    • Source table – Contains the changes that need to be applied to the target table
    • Target table – The table that requires changes (Inserts, Updates, Deletes)
  • Target and source are joined by a common column. Based on how the rows match up we can perform the relevant operations on the target table
  • Merge statements must be terminated with a semicolon

Resources