integer - beyond 2,147,483,647 -- sql server (microsoft)

aaron.kempf NO[at]SPAM gmail.com
12/6/2006 3:00:29 PM

you could use a 32bit server but use a 'BIGINT' if you wanted

-Aaron

[quoted text, click to view]

Russ Rose
12/6/2006 6:14:34 PM

[quoted text, click to view]

Correct. The 8 byte (64 bit) bigint data type would be the next step up.

However, if you are tight on space and only need numbering for 4 billion
rows or less, you can stay with the int data type and start you numbering
at -2,000,000,000.

You can also use the decimal/numeric datatype for an autonumber field.

[quoted text, click to view]

User
12/7/2006 12:41:58 AM

what happends if an auto number (identity column) of datatype "int" goes
beyond 2,147,483,647 ?

Does user have to go for 64 bit in this instance?

Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server (microsoft)

sql server (microsoft) : integer - beyond 2,147,483,647