SQL Server 2005 data types

Exact numerics Type From To bigint -9,223,372,036,854,775,808 9,223,372,036,854,775,807 int -2,147,483,648 2,147,483,647 smallint -32,768 32,767 tinyint 255 bit 1 decimal -10^38 +1 10^38 –1 numeric -10^38 +1 10^38 –1 money -922,337,203,685,477.5808 +922,337,203,685,477.5807 smallmoney -214,748.3648 +214,748.3647

numeric and decimal are Fixed precision and scale data types and are functionally equivalent.

Approximate numerics Type From To float -1.79E + 308 1.79E + 308 real -3.40E + 38 3.40E + 38 datetime and smalldatetime Type From To datetime (3.33 milliseconds accuracy) Jan 1, 1753 Dec 31, 9999 smalldatetime (1 minute accuracy) Jan 1, 1900 Jun 6, 2079 Character Strings Type Description char Fixed-length non-Unicode character data with a maximum length of 8,000 characters. varchar Variable-length non-Unicode data with a maximum of 8,000 characters. varchar(max) Variable-length non-Unicode data with a maximum length of 231 characters (SQL Server 2005 only). text Variable-length non-Unicode data with a maximum length of 2,147,483,647 characters. Unicode Character Strings Type Description nchar Fixed-length Unicode data with a maximum length of 4,000 characters. nvarchar Variable-length Unicode data with a maximum length of 4,000 characters. nvarchar(max) Variable-length Unicode data with a maximum length of 230 characters (SQL Server 2005 only). ntext Variable-length Unicode data with a maximum length of 1,073,741,823 characters. Binary Strings Type Description binary Fixed-length binary data with a maximum length of 8,000 bytes. varbinary Variable-length binary data with a maximum length of 8,000 bytes. varbinary(max) Variable-length binary data with a maximum length of 231 bytes (SQL Server 2005 only). image Variable-length binary data with a maximum length of 2,147,483,647 bytes.

Data types listed above.