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. www.iea-software.com
For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart