September 26, 2002 at 9:21 am
If I create a table and add an identity column called RowId but not have it as the primary key, am I guaranteed that every record entered will be in sequential order even after record deletions occur. (ie..The last record added must always have the highest RowId.)
September 26, 2002 at 10:13 am
No. this is an incremental field and the increment is stored in the system tables. Someone can alwyas insert their own value or the next value can be reset.
http://www.sqlservercentral.com/columnists/sjones/understandingyouridentity.asp
http://www.sqlservercentral.com/columnists/sjones/identitylocking.asp
Steve Jones
September 26, 2002 at 11:25 am
Thanks Steve. After reading your articles, we've decided to handle number incrementing on our own through our interfaces. Although this is not a huge 'bug', it's one I don't want to bite me sometime down the road.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply