| aspxtreme |
Home Getting Started Web Forms Web Applications ADO.NET ASP/ADO Back to Basics |
  |
SqlDbType Enumeration
Specifies SQL Server™ data types.
Members
| 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.
|
| 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.
|
| 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. |
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. 
