What is affected by IGNORE_DUP

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Hugo Kornelis » What is affected by IGNORE_DUP_KEY?

What is affected by IGNORE_DUP_KEY?

Rate Topic

Display Mode

Topic Options

Author

Message

Hugo Kornelis

Posted Monday, November 10, 2008 11:33 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 4:30 PM
Points: 5,235, Visits: 7,038

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

Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

Post #600418

ChiragNS

Posted Tuesday, November 11, 2008 1:11 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 5:02 AM
Points: 2,365, Visits: 1,825

MS should have included Merge also.

"Keep Trying"

Post #600454

Derek Dongray

Posted Tuesday, November 11, 2008 4:21 AM

Ten Centuries

Group: General Forum Members
Last Login: Monday, May 13, 2013 2:04 AM
Points: 1,342, Visits: 1,946

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

Post #600549

Anipaul

Posted Wednesday, November 12, 2008 3:20 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 6:03 AM
Points: 4,787, Visits: 1,335

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

Post #601221

« Prev Topic | Next Topic »

Permissions