See
Re: Record ID generator question Thread #
605839 Message #
611104.
>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
--sb--