General information
Forum:
Microsoft SQL Server
Hello Group,
Hello Group,
I have been thinking again, about primary keys.
It is said not to use @@IDENTITY, I forget why.
So, I would set up a table to store all my next values for all of my Primary Keys. If the next primary key is 256 for MyTable.MyNextpk and multiple users get the value 256 at the same time, each one incrementing the mynextPk value from 256 to 257 and inseting it back into mytable.myNextPk.
Let say there were 10 simutaneous hits. MyNextPK would be 257 instead of 266. Or would it?
Thanks
Jim
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only