共用方式為


SqlDataType Enumeration

The SqlDataType enumeration contains values that are used to specify a Microsoft SQL Server data type.

命名空間: Microsoft.SqlServer.Management.Smo
組件: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

語法

'宣告
Public Enumeration SqlDataType
public enum SqlDataType
public enum class SqlDataType
public enum SqlDataType
public enum SqlDataType

Members

Member name Description
BigInt A 64-bit signed integer.
Binary A fixed-length byte array ranging between 1 and 8,000 bytes.
Bit An unsigned bit value that can be 0, 1, or a null reference.
Char A fixed-length byte array of non-Unicode (256 code page) characters ranging between 1 and 8,000 characters.
DateTime A DateTime system object value that specifies a date and time between January 1, 1753 and December 31, 9999 to an accuracy of 3.33 milliseconds.
Decimal A fixed precision and fixed scale numeric value between -1038 -1 and +1038 -1.
Float An 8-byte floating point number within the range of -1.79E +308 through 1.79E +308.
Image A variable-length byte array ranging from 0 to 231 -1 (or 2,147,483,647) bytes.
Int A 32-bit signed integer.
Money A Decimal system object value that specifies 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 of 1 in 10,000 of a currency unit.
NChar A fixed-length byte array of Unicode characters ranging between 1 and 4,000 characters.
None No data type.
NText A variable-length byte array of Unicode data with a maximum length of 230 - 1 (or 1,073,741,823) characters.
Numeric A fixed precision and fixed scale numeric value between -1038 -1 and +1038 -1.
NVarChar A variable-length byte array of Unicode characters ranging between 1 and 2^63 characters.
NVarCharMax The NVARCHAR(MAX) type.
Real A 4-bit floating point number within the range of -3.40E +38 through 3.40E +38.
SmallDateTime A DataTime system object value that specifies a date and time between January 1, 1900 and June 6, 2079 to an accuracy of one minute.
SmallInt A 16-bit signed integer.
SmallMoney A Decimal system object value that specifies a currency value ranging from -214,748.3648 to +214,748.3647 with an accuracy of 1 in 10,000 of a currency unit.
SysName A system name string.
Text A variable-length byte array of non-Unicode (256 code page) data with a maximum length of 231 -1 (or 2,147,483,647) characters.
Timestamp An automatically generated byte array value, which is guaranteed to be unique within a database.
TinyInt An 8-bit unsigned integer.
UniqueIdentifier A globally unique identifier (or GUID).
UserDefinedDataType A user-defined data type.
UserDefinedType A SQLServer common language runtime (CLR) user-defined type.
VarBinary A variable-length byte array ranging between 1 and 2^64 bytes.
VarBinaryMax A VARBINARY(MAX) type.
VarChar A variable-length byte array of non-Unicode (256 cod epage) characters ranging between 1 and 2^64 characters.
VarCharMax A VARCHAR(MAX) type.
Variant A special data type that can contain numeric, string, binary, date data, and the Microsoft SQL Server values Empty and Null. This data type is assumed if no other type is declared.
Xml An XML data type.

備註

The SqlDataType enumeration class is served by the SqlDataType property.

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

平台

開發平台

如需受支援的平台清單,請參閱<安裝 SQL Server 2005 的硬體和軟體需求>。

目標平台

如需受支援的平台清單,請參閱<安裝 SQL Server 2005 的硬體和軟體需求>。

請參閱

參考

Microsoft.SqlServer.Management.Smo Namespace