Search
InstantDoc ID
GO

Browse By: Author | Issue

February 28, 2008 10:28 PM

MERGE

Merge source data into a target table
Rating: (0)
Itzik Ben-Gan
SQL Server Magazine
InstantDoc ID #97963

Executive Summary:
Some data modification tasks involve merging source data into a target table. Before Microsoft SQL Server 2008 you had to carry out such tasks with multiple modification statements, requiring you to access both the source and the target multiple times, and causing complexities in terms of handling the modifications as an atomic unit. Microsoft SQL Server 2008 adds the standard MERGE statement to simplify and optimize these tasks.


Some d...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Compare Member Benefits

Add a Comment

Leaned how to use merege after BOL didn't help me

Rimon3/8/2009 12:57:15 AM

Very useful ;)

Cem3/6/2008 2:33:56 PM

I have always wanted a SQL statement that did this! Great!!!

David3/5/2008 10:20:16 AM

You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS

© 2010 Penton Media, Inc.

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.