What is MERGE Statement?

Posted by

To view Verified answers click on the button below.

MERGE is a new feature that provides an efficient way to perform multiple DML
operations. In previous versions of SQL Server, we had to write separate statements to
INSERT, UPDATE, or DELETE data based on certain conditions, but now, using MERGE
statement we can include the logic of such data modifications in one statement that even
checks when the data is matched then just update it and when unmatched then insert it.
One of the most important advantages of MERGE statement is all the data is read and
processed only once.