Last post Oct 16, 2017 07:12 AM by Cathy Zou
Oct 14, 2017 04:55 AM|Baiju EP|LINK
Sir, In all my asp.net+VB+SQL web based projects I am using Int for ID. Is there any problem when the data is increased after a while.
Is there any limit for Int to get stopped after a while. If so what is the remedy for that.
Oct 16, 2017 07:12 AM|Cathy Zou|LINK
Hi Baiju EP,
Int represents an integer value that can be stored in 4 bytes. INT is the short form of integer.
The range of an int data type is -2,147,483,648 to 2,147,483,647.
Other maximum values:
1.BigInt: -9223372036854775808 through 9223372036854775807 (8 bytes)
2.SmallInt: -32768 through 32767 (2 bytes)
3.TinyInt: 0 through 255 (1 byte)
You should select data type base on your needs: