SQL Server 2008 New Features - Merge Statement
page 3 of 3
by Nidal Arabi
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 17753/ 25


Although the Merge Statement is very powerful and should be used whenever there is need, I do suggest that you do a lot of testing on it before you start using it. Also, you have to be really careful when using the merge statement about the identity column (you may be skipping ids or creating unrelated records in the target table). As a safety rule, the target table should not have an identity column as a foreign key inside the source table. See you in the next article with a new feature.

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-04-13 9:10:31 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search