0

When I try to use MS SQL Server Enterprise Manager to create table, I typed column name, data type as "int", however the length of "int" is 4, that is fixed I cannot change, now the problem is I need to use this column as record ID, my database is large, the number of the records is more than 9999(which is the maximum int 4 length), how can I solve this issue? thanks for any comment.

4
Contributors
5
Replies
8
Views
11 Years
Discussion Span
Last Post by Nemesis80
0

you are confused, int is not limited to less than 10,000 in sql server. the limit is around 2 billion. (2^31)-1 to be precise

0

Friend of mine INT 4 in sql server means that it uses 4 bytes if you multiply it by 8 bits each one they are 32 bits with what you can store numbers of the order from-2^31 (-2.147.483.648) to 2^31-1 (2.147.483.647)

see it

http://technet.microsoft.com/en-us/library/ms187745.aspx

bye

When I try to use MS SQL Server Enterprise Manager to create table, I typed column name, data type as "int", however the length of "int" is 4, that is fixed I cannot change, now the problem is I need to use this column as record ID, my database is large, the number of the records is more than 9999(which is the maximum int 4 length), how can I solve this issue? thanks for any comment.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.