If you have a primary key constraint on the OrderID column, there cannot be any duplicates. Would for some reason the IDENTITY generation be reset and start to generate duplicates (and this can happen), you will get an error when you insert.
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
No comments:
Post a Comment