Re: [Emerald] customer ID Question (autonumber) BIG QUESTION!

Dale E. Reed Jr. ( (no email) )
Fri, 03 Mar 2000 14:33:28 -0800

> Kenneth Jaeger wrote:
> I was just looking at the Database schema that came with emerald 2.5
> and noticed that the customerID is an integer autonumber. What is the
> max number that this field can support? (I think 32,768) what
> happens after that number is reached?

If you check your SQL Server docs, you'll see that an int in SQL
is 32-bit. Therefores its 2^31 (-1 for signed), or about 2 billion,
give or take a couple million.


Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc.

For more information about this list (including removal) go to: