Information générale
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement