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

What is affected by IGNORE_DUP_KEY? Expand / Collapse
Author
Message
Posted Monday, November 10, 2008 11:33 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:05 PM
Points: 5,793, Visits: 8,002
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
Posted Tuesday, November 11, 2008 1:11 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, March 19, 2014 1:27 AM
Points: 2,366, Visits: 1,837
MS should have included Merge also.

"Keep Trying"
Post #600454
Posted Tuesday, November 11, 2008 4:21 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, February 18, 2014 7:14 AM
Points: 1,344, Visits: 1,983
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
Posted Wednesday, November 12, 2008 3:20 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, March 20, 2014 7:32 AM
Points: 5,181, Visits: 1,368
Interesting thing from MS. May be they will rectify this to include merge latter.


Post #601221
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse