User-707554951 posted
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:
Related link:
http://www.c-sharpcorner.com/UploadFile/rohatash/maximum-limit-value-for-integer-data-type-in-sql-server-2012/
https://docs.microsoft.com/en-us/sql/t-sql/data-types/int-bigint-smallint-and-tinyint-transact-sql
Best Regards
Cathy
