| Member Name |
Description |
| BigInt |
Int64
A 64-bit signed integer. |
| Binary |
Array of type Byte
A fixed-length stream of binary data ranging between 1 and 8,000 bytes. |
| Bit |
Boolean
An unsigned numeric value that can be 0, 1, or a null reference. |
| Char |
String
A fixed-length stream of non-Unicode characters ranging between 1 and 8,000 characters. |
| DateTime |
DateTime
Date and time data ranging in value from January 1, 1753 to December 31, 9999 to an accuracy of 3.33 milliseconds. |
| Decimal |
Decimal
A fixed precision and scale numeric value between -1038 -1 and 10 38 -1. |
| Float |
Double
A floating point number within the range of -1.79E +308 through 1.79E +308. |
| Image |
Array of type Byte
A variable-length stream of binary data ranging from 0 to 231 -1 ( or 2,147,483,647 ) bytes. |
| Int |
Int32
A 32-bit signed integer. |
| Money |
Decimal
A currency value ranging from -263 ( or -922,337,203,685,477.5808 ) to 2 63 -1 ( or +922,337,203,685,477.5807 ) with an accuracy to a ten-thousandth of a currency unit. |
| NChar |
String
A fixed-length stream of Unicode characters ranging between 1 and 4,000 characters. |
| NText |
String
A variable-length stream of Unicode data with a maximum length of 230 - 1 ( or 1,073,741,823 ) characters. |
| NVarChar |
String
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.
|
| Real |
Single
A floating point number within the range of -3.40E +38 through 3.40E +38. |
| SmallDateTime |
DateTime
Date and time data ranging in value from January 1, 1900 to June 6, 2079 to an accuracy of one minute. |
| SmallInt |
Int16
A 16-bit signed integer. |
| SmallMoney |
Decimal
A currency value ranging from -214,748.3648 to +214,748.3647 with an accuracy to a ten-thousandth of a currency unit. |
| Text |
String
A variable-length stream of non-Unicode data with a maximum length of 231 -1 ( or 2,147,483,647 ) characters. |
| Timestamp |
DateTime
Data and time data in the format yyyymmddhhmmss. |
| TinyInt |
Byte
An 8-bit unsigned integer. |
| UniqueIdentifier |
Guid
A globally unique identifier ( or GUID ). |
| VarBinary |
Array of type Byte
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.
|
| VarChar |
String
A variable-length stream of non-Unicode characters ranging between 1 and 8,000 characters. |
| Variant |
Object
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. |
