What happens after 2^32 autonum keys are exhausted?

#81

On Aug 17, 11:38 am, "Tony Rogerson" <tonyroger... (AT) torver (DOT) net> wrote:

Quote:

I propose to stick the vendor's autoincremented ID on the license plate,
and be done with it. If two cars bear the same number, you can easily
distinguish them by the color. I'm not a natural key nazi, after all (*)

You must mean Jersey (Channel Islands)

http://en.wikipedia.org/wiki/British..._plates#Jersey

I think there is a unique constraint on the central database holding the
licence plate number though so your problem won't happen

Did you actually read his post. He suggested the AutoNum ID generated
BY EACH CAR DEALER,
IOW, no central DB.

Quote:

--
Tony Rogerson, SQL Server MVPhttp://sqlblogcasts.com/blogs/tonyrogerson
[Ramblings from the field from a SQL consultant]http://sqlserverfaq.com
[UK SQL User Community]

so did you see my answer to you VIN question?
I know you won't be staisdfied with it, but I don't want to be accused
of dodging the argument. The fact that I have given the answer several
times though might finally sink in.

Ed

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

What happens after 2^32 autonum keys are exhausted?

comp.databases comp.databases

Re: What happens after 2^32 autonum keys are exhausted? - 08-20-2007 , 07:19 AM