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.
michael123
0
Junior Poster in Training
Recommended Answers
Jump to Postyou 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
Jump to PostYes 4 relate to how many bytes int uses in ram per value
All 5 Replies
campkev
0
Posting Pro in Training
hollystyles
113
Veteran Poster
campkev
0
Posting Pro in Training
michael123
0
Junior Poster in Training
Nemesis80
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.