A 64-bit signed integer.

A fixed-length stream of binary data ranging between 1 and 8,000 bytes.

An unsigned numeric value that can be 0, 1, or a null reference.

A fixed-length stream of non-Unicode characters ranging between 1 and 8,000 characters.

Date and time data ranging in value from January 1, 1753 to December 31, 9999 to an accuracy of 3.33 milliseconds.

A fixed precision and scale numeric value between -10³⁸ -1 and 10 ³⁸ -1.

A floating point number within the range of -1.79E +308 through 1.79E +308.

A variable-length stream of binary data ranging from 0 to 2³¹ -1 ( or 2,147,483,647 ) bytes.

A 32-bit signed integer.

A currency value ranging from -2⁶³ ( or -922,337,203,685,477.5808 ) to 2 ⁶³ -1 ( or +922,337,203,685,477.5807 ) with an accuracy to a ten-thousandth of a currency unit.

A fixed-length stream of Unicode characters ranging between 1 and 4,000 characters.

A variable-length stream of Unicode data with a maximum length of 2³⁰ - 1 ( or 1,073,741,823 ) characters.

A variable-length stream of Unicode characters ranging between 1 and 4,000 characters.

NOTE: Implicit conversion fails if the string is greater than 4,000 characters. Explicitly set the object when working with strings longer than 4,000 characters.

A floating point number within the range of -3.40E +38 through 3.40E +38.

Date and time data ranging in value from January 1, 1900 to June 6, 2079 to an accuracy of one minute.

A 16-bit signed integer.

A currency value ranging from -214,748.3648 to +214,748.3647 with an accuracy to a ten-thousandth of a currency unit.

A variable-length stream of non-Unicode data with a maximum length of 2³¹ -1 ( or 2,147,483,647 ) characters.

Data and time data in the format yyyymmddhhmmss.

An 8-bit unsigned integer.

A globally unique identifier ( or GUID ).

A variable-length stream of binary data ranging between 1 and 8,000 bytes.

NOTE: Implicit conversion fails if the byte array is greater than 8,000 bytes. Explicitly set the object when working with byte arrays larger than 8,000 bytes.

A variable-length stream of non-Unicode characters ranging between 1 and 8,000 characters.

A special data type that can contain numeric, string, binary, or date data as well as the SQL Server™ values Empty and Null, which is assumed if no other type is declared.