DIFFERENCES BETWEEN TINYINT , SMALLINT & INT , BIGINT IN SQL SERVER 2005.

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.

Pawan Kumar
Pawankkmr@hotmail.com

Advertisements