Export (0) Print
Expand All
Expand Minimize

SqlDbType Enumeration

Specifies SQL Server-specific data type of a field, property, for use in a SqlParameter.

Namespace:  System.Data
Assembly:  System.Data (in System.Data.dll)

public enum SqlDbType

Member nameDescription
Supported by the .NET Compact FrameworkSupported by the XNA FrameworkBigIntInt64. A 64-bit signed integer.
Supported by the .NET Compact FrameworkSupported by the XNA FrameworkBinaryArray of type Byte. A fixed-length stream of binary data ranging between 1 and 8,000 bytes.
Supported by the .NET Compact FrameworkSupported by the XNA FrameworkBitBoolean. An unsigned numeric value that can be 0, 1, or null.
Supported by the .NET Compact FrameworkSupported by the XNA FrameworkCharString. A fixed-length stream of non-Unicode characters ranging between 1 and 8,000 characters.
Supported by the .NET Compact FrameworkSupported by the XNA FrameworkDateTimeDateTime. Date and time data ranging in value from January 1, 1753 to December 31, 9999 to an accuracy of 3.33 milliseconds.
Supported by the .NET Compact FrameworkSupported by the XNA FrameworkDecimalDecimal. A fixed precision and scale numeric value between -10 38 -1 and 10 38 -1.
Supported by the .NET Compact FrameworkSupported by the XNA FrameworkFloatDouble. A floating point number within the range of -1.79E +308 through 1.79E +308.
Supported by the .NET Compact FrameworkSupported by the XNA FrameworkImageArray of type Byte. A variable-length stream of binary data ranging from 0 to 2 31 -1 (or 2,147,483,647) bytes.
Supported by the .NET Compact FrameworkSupported by the XNA FrameworkIntInt32. A 32-bit signed integer.
Supported by the .NET Compact FrameworkSupported by the XNA FrameworkMoneyDecimal. A currency value ranging from -2 63 (or -9,223,372,036,854,775,808) to 2 63 -1 (or +9,223,372,036,854,775,807) with an accuracy to a ten-thousandth of a currency unit.
Supported by the .NET Compact FrameworkSupported by the XNA FrameworkNCharString. A fixed-length stream of Unicode characters ranging between 1 and 4,000 characters.
Supported by the .NET Compact FrameworkSupported by the XNA FrameworkNTextString. A variable-length stream of Unicode data with a maximum length of 2 30 - 1 (or 1,073,741,823) characters.
Supported by the .NET Compact FrameworkSupported by the XNA FrameworkNVarCharString. A variable-length stream of Unicode characters ranging between 1 and 4,000 characters. 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.
Supported by the .NET Compact FrameworkSupported by the XNA FrameworkRealSingle. A floating point number within the range of -3.40E +38 through 3.40E +38.
Supported by the .NET Compact FrameworkSupported by the XNA FrameworkUniqueIdentifierGuid. A globally unique identifier (or GUID).
Supported by the .NET Compact FrameworkSupported by the XNA FrameworkSmallDateTimeDateTime. Date and time data ranging in value from January 1, 1900 to June 6, 2079 to an accuracy of one minute.
Supported by the .NET Compact FrameworkSupported by the XNA FrameworkSmallIntInt16. A 16-bit signed integer.
Supported by the .NET Compact FrameworkSupported by the XNA FrameworkSmallMoneyDecimal. A currency value ranging from -214,748.3648 to +214,748.3647 with an accuracy to a ten-thousandth of a currency unit.
Supported by the .NET Compact FrameworkSupported by the XNA FrameworkTextString. A variable-length stream of non-Unicode data with a maximum length of 2 31 -1 (or 2,147,483,647) characters.
Supported by the .NET Compact FrameworkSupported by the XNA FrameworkTimestampArray of type Byte. Automatically generated binary numbers, which are guaranteed to be unique within a database. timestamp is used typically as a mechanism for version-stamping table rows. The storage size is 8 bytes.
Supported by the .NET Compact FrameworkSupported by the XNA FrameworkTinyIntByte. An 8-bit unsigned integer.
Supported by the .NET Compact FrameworkSupported by the XNA FrameworkVarBinaryArray of type Byte. A variable-length stream of binary data ranging between 1 and 8,000 bytes. 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.
Supported by the .NET Compact FrameworkSupported by the XNA FrameworkVarCharString. A variable-length stream of non-Unicode characters ranging between 1 and 8,000 characters.
Supported by the .NET Compact FrameworkSupported by the XNA FrameworkVariantObject. 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.
Supported by the .NET Compact FrameworkSupported by the XNA FrameworkXmlAn XML value. Obtain the XML as a string using the GetValue method or Value property, or as an XmlReader by calling the CreateReader method.
Supported by the .NET Compact FrameworkSupported by the XNA FrameworkUdtA SQL Server 2005 user-defined type (UDT).
Supported by the .NET Compact FrameworkSupported by the XNA FrameworkStructuredA special data type for specifying structured data contained in table-valued parameters.
Supported by the .NET Compact FrameworkSupported by the XNA FrameworkDateDate data ranging in value from January 1,1 AD through December 31, 9999 AD.
Supported by the .NET Compact FrameworkSupported by the XNA FrameworkTimeTime data based on a 24-hour clock. Time value range is 00:00:00 through 23:59:59.9999999 with an accuracy of 100 nanoseconds. Corresponds to a SQL Server time value.
Supported by the .NET Compact FrameworkSupported by the XNA FrameworkDateTime2Date and time data. Date value range is from January 1,1 AD through December 31, 9999 AD. Time value range is 00:00:00 through 23:59:59.9999999 with an accuracy of 100 nanoseconds.
Supported by the .NET Compact FrameworkSupported by the XNA FrameworkDateTimeOffsetDate and time data with time zone awareness. Date value range is from January 1,1 AD through December 31, 9999 AD. Time value range is 00:00:00 through 23:59:59.9999999 with an accuracy of 100 nanoseconds. Time zone value range is -14:00 through +14:00.

When setting command parameters, the SqlDbType and DbType are linked. Therefore, setting the DbType changes the SqlDbType to a supporting SqlDbType.

Windows 7, Windows Vista, Windows XP SP2, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP Starter Edition, Windows Server 2008 R2, Windows Server 2008, Windows Server 2003, Windows Server 2000 SP4, Windows Millennium Edition, Windows 98, Windows CE, Windows Mobile for Smartphone, Windows Mobile for Pocket PC, Xbox 360, Zune

The .NET Framework and .NET Compact Framework do not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

.NET Framework

Supported in: 3.5, 3.0, 2.0, 1.1, 1.0

.NET Compact Framework

Supported in: 3.5, 2.0, 1.0

XNA Framework

Supported in: 3.0, 2.0, 1.0

Community Additions

ADD
Show:
© 2014 Microsoft