is there any datatye that can accept 16 digit number
bit type is stored in 1 bit,
tinyint in 1byte,
smallint in 2 byte,(16bit ,I guess this is what you want)
int in 4 byte,
bigint in 8 byte
|||sorry it is not 16 bit number it is 16 digit number like 1234567891234567
|||See the BOL for BIGINT:bigint
-2^63 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807)
8 Bytes
HTH, Jens Suessmeyer.
http://www.sqlserver2005.desql
