Re: Identity columns

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Rick Sawtell (ricksawtell_at_hotmail.com)
Date: 10/07/04 

Date: Thu, 7 Oct 2004 15:50:11 -0700

Each integer datatype will allow so many as David pointed out.

So a tinying (1 byte = 8 bits) = 2^8 or 256
smallint (2 bytes = 16 bits) = 2^16 or 32767
int (4 bytes = 32 bits) = 2^32 or 2.14 billion
bigint (8 byte = 64 bits) = 2^64 or a whole bunch

You can also use a scaled integer like decimal, just set the scale to 0.
Decimal(15,0) = a really really big number.

Rick Sawtell
MCT, MCSD, MCDBA

"David Portas" <REMOVE_BEFORE_REPLYING_dportas@acm.org> wrote in message
news:BKWdnc2hu_wFJ_jcRVn-ig@giganews.com...
> The maximum value is determined by the datatype. In this case you've used
> INT for which the maximum is 2,147,483,647. So you have some way to go yet
> ...
>
> --
> David Portas
> SQL Server MVP
> --
>
>