Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Understanding the MERGE DML Statement in SQL Server 2008 Expand / Collapse
Author
Message
Posted Saturday, December 06, 2008 6:38 PM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, November 06, 2013 12:59 AM
Points: 15, Visits: 125
Comments posted to this topic are about the item Understanding the MERGE DML Statement in SQL Server 2008

Tharindu Dhaneenja.
MCTS,MCITP(SQL Server),OCA(Oracle)
http://dhaneenja.blogspot.com
Post #615207
Posted Monday, December 08, 2008 2:50 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Sunday, March 30, 2014 6:50 AM
Points: 313, Visits: 377
Well written...

Although I do have a point to add on just for the sake of it.....Its concerning the limitation of the Merge Command.

"The merge command could be used only on those tables which do not have duplicate records."

Actually this point is more of a reminder to all those creating tables to have a primary key to them. The way I look at it, once you keep in check that your database is atleast in the 1NF, then the Merge can be used and the above mentioned limitation would never be a concern :D

Post #615413
Posted Monday, December 08, 2008 3:18 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, November 06, 2013 12:59 AM
Points: 15, Visits: 125
Hi Linson.Daniel,
Thanks for send comments for my article yes you are correct. I mention this for limitation because give idea to "doesn’t apply duplicate data to MERGE DML”


Tharindu Dhaneenja.
MCTS,MCITP(SQL Server),OCA(Oracle)
http://dhaneenja.blogspot.com
Post #615424
Posted Monday, December 08, 2008 8:24 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, March 20, 2014 7:32 AM
Points: 5,181, Visits: 1,368
Well written and good article...:)


Post #615565
Posted Monday, December 08, 2008 8:39 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, March 06, 2014 4:48 AM
Points: 52, Visits: 270
Good article to start learn about new features of SQL Server 2008.

Susantha
Post #615576
Posted Wednesday, November 06, 2013 1:02 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, November 06, 2013 12:59 AM
Points: 15, Visits: 125
Hi All,
hope this will help you,
Link.

Thanks
Tharindu


Tharindu Dhaneenja.
MCTS,MCITP(SQL Server),OCA(Oracle)
http://dhaneenja.blogspot.com
Post #1511740
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse