Microsoft SQL Server Data Type

Supported SQL Server Data Types

Data Type Description
BIGINT Integer (whole number) data from -2^63 (-9223372036854775808) through 2^63-1 (9223372036854775807).
INT Integer (whole number) data from -2^31 (-2,147,483,648) through 2^31 – 1 (2,147,483,647).
SMALLINT Integer data from 2^15 (-32,768) through 2^15 – 1 (32,767).
TINYINT Integer data from 0 through 255.
BIT Integer data with either a 1 or 0 value.
DECIMAL Fixed precision and scale numeric data from -10^38 +1 through 10^38 –1.
NUMERIC Functionally equivalent to decimal.
MONEY Monetary data values from -2^63 (-922,337,203,685,477.5808) through 2^63 – 1 (+922,337,203,685,477.5807), with accuracy to a ten-thousandth of a monetary unit.
SMALLMONEY Monetary data values from -214,748.3648 through +214,748.3647, with accuracy to a ten-thousandth of a monetary unit.
FLOAT Floating precision number data from -1.79E + 308 through 1.79E + 308.
REAL Floating precision number data from -3.40E + 38 through 3.40E + 38.
DATETIME Date and time data from January 1, 1753, through December 31, 9999, with an accuracy of three-hundredths of a second, or 3.33 milliseconds.
SMALLDATETIME Date and time data from January 1, 1900, through June 6, 2079, with an accuracy of one minute.
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.
TEXT Variable-length non-Unicode data with a maximum length of 2^31 – 1 (2,147,483,647) characters.
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. sysname is a system-supplied user-defined data type that is functionally equivalent to nvarchar(128) and is used to reference database object names.
NTEXT Variable-length Unicode data with a maximum length of 2^30 – 1 (1,073,741,823) characters.
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.
IMAGE Variable-length binary data with a maximum length of 2^31 – 1 (2,147,483,647) bytes.
CURSOR A reference to a cursor.
SQL_VARIANT A data type that stores values of various SQL Server-supported data types, except text, ntext, timestamp, and sql_variant.
TABLE A special data type used to store a result set for later processing.
TIMESTAMP A database-wide unique number that gets updated every time a row gets updated.
UNIQUEIDENTIFIER A globally unique identifier (GUID).

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.