New article posted on Merge statement for SQL Server 2008. You can check the article from the link below.
In earlier versions of SQL Server in order to perform INSERT, UPDATE or DELETE we have to have separate T-SQL statements. With the introduction of SQL Server 2008 we have MERGE statement which helps in simplifying this. It allows us to perform DML operations based on certain JOIN conditions in single statement.
The Merge statement basically has two tables namely source table and destination table. We have to perform a join between them using a certain condition. If the condition matches certain action is performed in the target table. If the condition doesn’t matches some other action is performed and so on.