MERGE in SQL Server

Hello All,

This one is nice to have while handling the table types may be anyone of you already know this.

Scenario: we passed the table type as parameter and we want to check upon

the database values and table type values, Then runtime decide the action to update/insert/delete the

Records in table.,

Solution:
MERGE (Transact-SQL)

Performs insert, update, or delete operations on a target table based on the results of a join with a source table.
For example, you can synchronize two tables by inserting, updating, or deleting rows in one table based on differences found in the other table.

For more information: http://technet.microsoft.com/en-us/library/bb510625.aspx

Posted in:

Leave a Reply