|
|
|
Grasshopper
      
Group: General Forum Members
Last Login: Friday, June 15, 2012 4:45 AM
Points: 14,
Visits: 122
|
|
|
|
|
|
Old Hand
      
Group: General Forum Members
Last Login: Saturday, March 02, 2013 8:26 PM
Points: 312,
Visits: 367
|
|
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
|
|
|
|
|
Grasshopper
      
Group: General Forum Members
Last Login: Friday, June 15, 2012 4:45 AM
Points: 14,
Visits: 122
|
|
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
|
|
|
|
|
SSCarpal Tunnel
       
Group: General Forum Members
Last Login: Thursday, May 16, 2013 2:50 AM
Points: 4,786,
Visits: 1,334
|
|
Well written and good article...:)
|
|
|
|
|
Valued Member
      
Group: General Forum Members
Last Login: Wednesday, August 08, 2012 1:53 AM
Points: 52,
Visits: 255
|
|
Good article to start learn about new features of SQL Server 2008.
Susantha
|
|
|
|