Post reply

Understanding the MERGE DML Statement in SQL Server 2008

  • December 6, 2008 at 6:38 pm

    #196709

    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

  • December 8, 2008 at 2:50 am

    #909044

    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 😀

  • December 8, 2008 at 3:18 am

    #909051

    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

  • December 8, 2008 at 8:24 am

    #909167

    Well written and good article...:)

  • December 8, 2008 at 8:39 am

    #909176

    Good article to start learn about new features of SQL Server 2008.

    Susantha

  • November 6, 2013 at 1:02 am

    #1664345

    Hi All,

    hope this will help you,

    Link.

    Thanks

    Tharindu

    Tharindu Dhaneenja.
    MCTS,MCITP(SQL Server),OCA(Oracle)
    http://www.databaseusergroup.com

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply