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 6, 2008 6:38 PM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, November 24, 2014 2:48 AM
Points: 16, Visits: 131
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://www.databaseusergroup.com
Post #615207
Posted Monday, December 8, 2008 2:50 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, June 4, 2014 3:27 AM
Points: 313, Visits: 382
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 8, 2008 3:18 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, November 24, 2014 2:48 AM
Points: 16, Visits: 131
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://www.databaseusergroup.com
Post #615424
Posted Monday, December 8, 2008 8:24 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 1:47 AM
Points: 5,449, Visits: 1,401
Well written and good article...:)


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

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, June 25, 2014 9:48 AM
Points: 52, Visits: 275
Good article to start learn about new features of SQL Server 2008.

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


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, November 24, 2014 2:48 AM
Points: 16, Visits: 131
Hi All,
hope this will help you,
Link.

Thanks
Tharindu


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

Add to briefcase

Permissions Expand / Collapse