SqlDbType SqlDbType SqlDbType SqlDbType Enum

Definition

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

Fields

BigInt BigInt BigInt BigInt 0

Int64. A 64-bit signed integer.

Binary Binary Binary Binary 1

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

Bit Bit Bit Bit 2

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

Char Char Char Char 3

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

Date Date Date Date 31

Date data ranging in value from January 1,1 AD through December 31, 9999 AD.

DateTime DateTime DateTime 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.

DateTime2 DateTime2 DateTime2 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 DateTimeOffset DateTimeOffset 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.

Decimal Decimal Decimal Decimal 5

Decimal. A fixed precision and scale numeric value between -10 38 -1 and 10 38 -1.

Float Float Float Float 6

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

Image Image Image 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 Int Int Int 8

Int32. A 32-bit signed integer.

Money Money Money 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 NChar NChar NChar 10

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

NText NText NText 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 NVarChar NVarChar 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 Real Real Real 13

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

SmallDateTime SmallDateTime SmallDateTime 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 SmallInt SmallInt SmallInt 16

Int16. A 16-bit signed integer.

SmallMoney SmallMoney SmallMoney 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.

Structured Structured Structured Structured 30

A special data type for specifying structured data contained in table-valued parameters.

Text Text Text 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.

Time Time Time 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.

Timestamp Timestamp Timestamp 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 TinyInt TinyInt TinyInt 20

Byte. An 8-bit unsigned integer.

Udt Udt Udt Udt 29

A SQL Server user-defined type (UDT).

UniqueIdentifier UniqueIdentifier UniqueIdentifier UniqueIdentifier 14

Guid. A globally unique identifier (or GUID).

VarBinary VarBinary VarBinary 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 VarChar VarChar 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 Variant Variant 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 Xml Xml 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.

Remarks

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

Applies to