Smallint is 2 bytes and stores values between -32768 and 32767
Int is 4 bytes and stores values betweeen -2,147,483,648 and 2,147,483,647
bigint is 8 bytes and stores values between -9,223,372,036,854,775,808 and 9,223,372,036,854,775,807
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability