SQL Server 2008 New Features - Merge Statement
page 1 of 3
Published: 22 Aug 2008
Abstract
In this article Nidal examines the usage of a SQL Server 2008 feature named Merge statement. It is a new TSQL 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.
by Nidal Arabi
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 17780/ 35

Introduction

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 for example.

Requirements

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.


View Entire Article

User Comments

No comments posted yet.






Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2024 ASPAlliance.com  |  Page Processed at 2024-03-28 2:52:29 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search