Int, bigint, smallint, and tinyint

Int, bigint, smallint, and tinyint

Use the exact numeric data type of integer data. Bigint Integer Data from-2 ^ 63 (-9223372036854775808) to 2 ^ 63-1 (9223372036854775807) (All numbers ). The storage size is 8 bytes. Int Integer Data from-2 ^ 31 (-2,147,483,648) to 2 ^ 31-1 (2,147,483,647) (All numbers ). The storage size is 4 bytes.IntThe SQL-92Integer. Smallint Integer Data from-2 ^ 15 (-32,768) to 2 ^ 15-1 (32,767. The storage size is 2 bytes. Tinyint Integer Data from 0 to 255. The storage size is 1 byte. Note Supported by integerBigintData type. However,BigintUsed in some special cases, when the integer value exceedsIntYou can useBigint. In SQL Server,IntThe data type is the main integer data type. In the data type priority table,BigintLocated inSmallmoneyAndInt. Only when the parameter expression isBigintThe function returns the data type.Bigint. SQL Server does not automatically convert other integer data types (Tinyint,SmallintAndInt)Bigint.