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.
Jump to Post
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
All 5 Replies
We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.