What is MERGE statement in SQL SERVER 2008?

 Posted by Sumank on 5/17/2013 | Category: Sql Server Interview questions | Views: 1913 | Points: 40

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.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response