SQL Server 2008 - Merge Statement
In this article Nidal Arabi examines the usage of a SQL Server 2008 feature named Merge statement. It is a new T-SQL Statement that allows you to perform join of tables and then apply one of three different operations on the result set. He demonstrates the concepts with the help of step-by-step explanations accompanied by relevant SQL statements.