Datatype Range Storage (bytes)
bigint -2^63 to 2^63-1 8
int -2^31 to 2^31-1 4
smallint -2^15 to 2^15-1 2
tinyint 0 to 255 1
money -922,337,203,685,477.5808 to 8
922,337,203,685,477.5807,
with accuracy of one
ten-thousandth of a monetary unit
smallmoney -214,748.3648 to 214,748.3647, 4
with accuracy of one
ten-thousandth of a monetary unit
|