SqlDataType-Enumeration

SQL Server built-in data types

Namespace:  Microsoft.SqlServer.Dac.Model
Assembly:  Microsoft.SqlServer.Dac.Extensions (in Microsoft.SqlServer.Dac.Extensions.dll)

Syntax

'Declaration
Public Enumeration SqlDataType
'Usage
Dim instance As SqlDataType

public enum SqlDataType

public enum class SqlDataType

type SqlDataType

public enum SqlDataType

Elemente

	Elementname	Beschreibung
	BigInt	Integer (whole number) data from -2^63 (-9,223,372,036,854,775,808) through 2^63-1 (9,223,372,036,854,775,807).
	Binary	Fixed-length binary data with a maximum length of 8,000 bytes.
	Bit	Integer data with either a 1 or 0 value.
	Char	Fixed-length non-Unicode character data with a maximum length of 8,000 characters.
	Cursor	A reference to a cursor.
	Date	Date-only
	DateTime	Date and time data from January 1, 1753, through December 31, 9999, with an accuracy of three-hundredths of a second, or 3.33 milliseconds.
	DateTime2	Combination of data and time types, better precision than DataTime
	DateTimeOffset	Same as DateTime2 with timezone offset added
	Decimal	Fixed precision and scale numeric data from -10^38 +1 through 10^38 -1.
	Float	Floating precision number data with the following valid values: -1.79E + 308 through -2.23E - 308, 0 and 2.23E + 308 through 1.79E + 308.
	Image	Variable-length binary data with a maximum length of 2^31 - 1 (2,147,483,647) bytes.
	Int	Integer (whole number) data from -2^31 (-2,147,483,648) through 2^31 - 1 (2,147,483,647).
	Money	Monetary data values from -2^63 (-922,337,203,685,477.5808) through 2^63 - 1 (+922,337,203,685,477.5807), with accuracy to a ten-thousandth of a monetary unit.
	NChar	Fixed-length Unicode data with a maximum length of 4,000 characters.
	NText	Variable-length Unicode data with a maximum length of 2^30 - 1 (1,073,741,823) characters.
	Numeric	Functionally equivalent to decimal.
	NVarChar	Variable-length Unicode data with a maximum length of 4,000 characters. sysname is a system-supplied user-defined data type that is functionally equivalent to nvarchar(128) and is used to reference database object names.
	Real	Floating precision number data with the following valid values: -3.40E + 38 through -1.18E - 38, 0 and 1.18E - 38 through 3.40E + 38.
	Rowversion	(Alias for Timestamp) A database-wide unique number that gets updated every time a row gets updated.
	SmallDateTime	Date and time data from January 1, 1900, through June 6, 2079, with an accuracy of one minute.
	SmallInt	Integer data from -2^15 (-32,768) through 2^15 - 1 (32,767).
	SmallMoney	Monetary data values from -214,748.3648 through +214,748.3647, with accuracy to a ten-thousandth of a monetary unit.
	Table	A special data type used to store a result set for later processing.
	Text	Variable-length non-Unicode data with a maximum length of 2^31 - 1 (2,147,483,647) characters.
	Time	Time only
	Timestamp	A database-wide unique number that gets updated every time a row gets updated.
	TinyInt	Integer data from 0 through 255.
	UniqueIdentifier	Is a 16-byte GUID
	Unknown	Nothing was defined.
	VarBinary	Variable-length binary data with a maximum length of 8,000 bytes.
	VarChar	Variable-length non-Unicode data with a maximum of 8,000 characters.
	Variant	A data type that stores values of various SQL Server-supported data types, except text, ntext, timestamp, and sql_variant.
	Xml	xml data type

Siehe auch

Verweis

Microsoft.SqlServer.Dac.Model-Namespace