int, smallint, and tinyint (T-SQL)

Exact number data types that use integer data.

int
Integer (whole number) data from -2^31 (-2,147,483,648) through 2^31 - 1 (2,147,483,647). Storage size is 4 bytes. The SQL-92 synonym for int is integer.
smallint
Integer data from -2^15 (-32,768) through 2^15 - 1 (32,767). Storage size is 2 bytes.
tinyint
Integer data from 0 through 255. Storage size is 1 byte.
See Also
ALTER TABLE DECLARE @local_variable
CAST and CONVERT DELETE
CREATE TABLE INSERT
Data Type Conversion SET @local_variable
Data Types UPDATE

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.