Merge statement in sql server 2008
Posted on November 17th , 2011 by Admin
|
|
MERGE statement comes in SQL Server 2008 which provide an efficient way to perform multiple operations at same time. In the older version we will write separate statement to INSERT,DELETE and UPDATE data based on certain conditions. But in SQL Server 2008 now by using MERGE statement we can include the logic of such data modification in one statement that even checks when the data matched then just update it and when unmatched then insert it. most importa |
| nt advantage of MERGE statement is all the data is read and processed only once. |
|
|
