SqlDbType Enum

Definition

Namespace:

System.Data

Assembly:

System.Data.Common.dll

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

public enum class SqlDbType

public enum SqlDbType

type SqlDbType = 

Public Enum SqlDbType

Inheritance

Object

ValueType

Enum

SqlDbType

Fields

Name	Value	Description
BigInt	0	Int64. A 64-bit signed integer.
Binary	1	Array of type Byte. A fixed-length stream of binary data ranging between 1 and 8,000 bytes.
Bit	2	Boolean. An unsigned numeric value that can be 0, 1, or null.
Char	3	String. A fixed-length stream of non-Unicode characters ranging between 1 and 8,000 characters.
DateTime	4	DateTime. Date and time data ranging in value from January 1, 1753 to December 31, 9999 to an accuracy of 3.33 milliseconds.
Decimal	5	Decimal. A fixed precision and scale numeric value between -10 38 -1 and 10 38 -1.
Float	6	Double. A floating point number within the range of -1.79E +308 through 1.79E +308.
Image	7	Array of type Byte. A variable-length stream of binary data ranging from 0 to 2 31 -1 (or 2,147,483,647) bytes.
Int	8	Int32. A 32-bit signed integer.
Money	9	Decimal. 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.
NChar	10	String. A fixed-length stream of Unicode characters ranging between 1 and 4,000 characters.
NText	11	String. A variable-length stream of Unicode data with a maximum length of 2 30 - 1 (or 1,073,741,823) characters.
NVarChar	12	String. 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. Use NVarChar when the database column is nvarchar(max).
Real	13	Single. A floating point number within the range of -3.40E +38 through 3.40E +38.
UniqueIdentifier	14	Guid. A globally unique identifier (or GUID).
SmallDateTime	15	DateTime. Date and time data ranging in value from January 1, 1900 to June 6, 2079 to an accuracy of one minute.
SmallInt	16	Int16. A 16-bit signed integer.
SmallMoney	17	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	18	String. A variable-length stream of non-Unicode data with a maximum length of 2 31 -1 (or 2,147,483,647) characters.
Timestamp	19	Array 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.
TinyInt	20	Byte. An 8-bit unsigned integer.
VarBinary	21	Array 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.
VarChar	22	String. A variable-length stream of non-Unicode characters ranging between 1 and 8,000 characters. Use VarChar when the database column is varchar(max).
Variant	23	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.
Xml	25	An XML value. Obtain the XML as a string using the GetValue(Int32) method or Value property, or as an XmlReader by calling the CreateReader() method.
Udt	29	A SQL Server user-defined type (UDT).
Structured	30	A special data type for specifying structured data contained in table-valued parameters.
Date	31	Date data ranging in value from January 1,1 AD through December 31, 9999 AD.
Time	32	Time 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.
DateTime2	33	Date 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.
DateTimeOffset	34	Date 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.

Remarks

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

See also

• Configuring Parameters and Parameter Data Types (ADO.NET)
• Data Type Mappings
• SQL Server Data Types and ADO.NET