Merge in SQL Server
Click here to Subscribe to IT PORT Channel : / @itport28
Merge Statement Performs insert, update, or delete operations on a target table based on the results of a join with a source table. For example, you can synchronize two tables by inserting, updating, or deleting rows in one table based on differences found in the other table