Post reply

What is affected by IGNORE_DUP_KEY?

  • November 10, 2008 at 11:33 pm

    #195691

    Comments posted to this topic are about the item What is affected by IGNORE_DUP_KEY?

    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

  • November 11, 2008 at 1:11 am

    #896774

    MS should have included Merge also.

    "Keep Trying"

  • November 11, 2008 at 4:21 am

    #896850

    The response to the bug report simply says this is 'by design'. It would be useful to know why this design decision was taken and whether it should be reviewed, since I, like most people, would expect a multiple row insert, whether the result of INSERT or MERGE, to behave the same way.

    Of course, since 2k8 is already released it's possible that applications already exist which rely on this behaviour, but personnally I'd be surprised.

    Derek

  • November 12, 2008 at 3:20 am

    #897398

    Interesting thing from MS. May be they will rectify this to include merge latter.

Viewing 4 posts - 1 through 3 (of 3 total)

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