4. What is MERGE Statement?

What is MERGE Statement?

Answer

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

All sql Questions
Ask your interview questions on sql

Write Your comment or Questions if you want the answers on sql from sql Experts
Name* :
Email Id* :
Mob no* :
Question
Or
Comment* :
 





Disclimer: PCDS.CO.IN not responsible for any content, information, data or any feature of website. If you are using this website then its your own responsibility to understand the content of the website

--------- Tutorials ---