MERGE statement is used to modify data in a target table based on data in a source table. The statement joins the target to the source by using a column which is common to both the tables. We can INSERT, UPDATE, or DELETE data from the target table-all in one statement-according to how the rows match up as a result of the join. This lab is divided into five exercises explaining different scenarios where MERGE statement is useful such as INSERT and UPDATE the rows using MERGE, UPDATE and DELETE rows using MERGE and INSERT, UPDATE and DELETE rows using MERGE.

Subscribe to Download


Version1.0
Download6
File Size753.40 KB
Create DateSeptember 12, 2016
Last UpdatedSeptember 12, 2016
LAG and LEAD Functions in SQL Server
OFFSET and FETCH in SQL Server