DIFFERENCES BETWEEN TINYINT , SMALLINT & INT , BIGINT IN SQL SERVER
Similarities and Differences.
1.TINYINT
Minimum Value : 0
Maximum Value : 255
Storage size : 1 byte
2.SMALLINT
Minimum Value : -32768
Maximum Value : 32767
Storage size : 2 bytes
3.INT
Minimum Value : -2^31
Maximum Value : 2^31 – 1
Storage size : 4 bytes
4.BIGINT
Minimum Value : -2^63
Maximum Value : 2^63 – 1
Storage size : 8 Bytes.
Similarities and Differences.
1.TINYINT
Minimum Value : 0
Maximum Value : 255
Storage size : 1 byte
2.SMALLINT
Minimum Value : -32768
Maximum Value : 32767
Storage size : 2 bytes
3.INT
Minimum Value : -2^31
Maximum Value : 2^31 – 1
Storage size : 4 bytes
4.BIGINT
Minimum Value : -2^63
Maximum Value : 2^63 – 1
Storage size : 8 Bytes.
No comments:
Post a Comment