Microsoft SQL Server 2008 with its release included some new
features that some of us (as developers) will find interesting and useful. In
this article about the new features of SQL Server 2008, I will try to shed some
light on the Merge Statement feature (a nifty addition) as attributed to the
family of T-SQL.
About The Feature
Before the merge statement was introduced, a developer was
required to do multiple statements to correct database status including
creation of temporary table as well as writing successive queries. I will show
in this article how to use the merge statement to enhance database integrity
In order to apply the article procedures, you should have
installed any version of Microsoft SQL Server 2008 (Express, Standard,
Developer, or Enterprise) and applied the first article of this series - SQL Server 2008 New
Features - Row Constructors.