What is the purpose of MERGE in sql server 2008?

Options
- Merge statement allows a single statement for INSERT, DELETE and UPDATE a row that depends on a condition
- Merge statement allows multiple statements for INSERT, DELETE and UPDATE a row that depends on a condition
- Merge statement allows a single statement for INSERT, DELETE and UPDATE a row that is independant on a condition
- Merge statement allows multiple statements for INSERT, DELETE and UPDATE a row that is independant on a condition


CORRECT ANSWER : Merge statement allows a single statement for INSERT, DELETE and UPDATE a row that depends on a condition

Discussion Board
SQL Server

In SQL Server 2008, you can perform insert, update, or delete operations in a single statement using the MERGE statement. The MERGE statement allows you to join a data source with a target table or view, and then perform multiple actions against the target based on the results of that join.

Prajakta Pandit 03-3-2017 06:50 AM

Write your comments

 
   
 
 

Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement