Prerequisite – MERGE Statement MERGE statement in SQL as discussed before is the combination of three INSERT, DELETE and UPDATE statements and with the help of MERGE statement we can perform all these three operations in our main target table when source table provided….

Source: http://www.geeksforgeeks.org/merge-statement-sql-explained/