Re: Negative Numbers in "Identity" or" Autonumber" fields

>> Any thought's on using negative numbers as surrogate primary keys? <<

Since surrogatres are never seen by the users by definition, they could be anything -- positive or negative, or additive congruence sequences or has code or etc. The question would be in implementation -- does the particular SQL engine favor a sequence or a randomly distributed value for performance min whatever access method it is using? Received on Tue Mar 20 2007 - 02:09:40 CET