SqlDataType 列舉
The SqlDataType enumeration contains values that are used to specify a SQL Server data type.
命名空間： Microsoft.SqlServer.Management.Smo
組件： Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)
語法
'宣告
Public Enumeration SqlDataType
'用途
Dim instance As SqlDataType
public enum SqlDataType
public enum class SqlDataType
type SqlDataType
public enum SqlDataType
成員
| 成員名稱 | 說明 | |
|---|---|---|
| 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. | |
| Date | Date object represents any valid Gregorian calendar date between '0001-01-01' CE and '9999-12-31' CE. | |
| 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. | |
| DateTime2 | DateTime2 is considered an extension of the existing DATETIME object with a large date range and large default fractional precision. Values that represent any valid Gregorian calendar date between ‘0001-01-01’ CE and ‘9999-12-31’ CE combined with any valid time of day based on a 24-hour clock. | |
| DateTimeOffset | DateTimeOffset returns valid Gregorian calendar date between `0001-01-01’ and ‘9999-12-31’ with any valid time of day based on a 24 hour format between ’00:00:00’ and max ’23:59:49.9999999’. Included in the DateTimeOffset is a time zone offset that must be between ‘-14:00’ and ‘+14:00’. | |
| 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. | |
| Geography | Geography spatial type represents data in a round-earth coordinate system. The SQL Server geography data type stores ellipsoidal (round-earth) data, such as GPS latitude and longitude coordinates.. | |
| Geometry | Geometry spatial type represents data in a Euclidean (flat) coordinate system. | |
| HierarchyId | HierarchyID type represents data in a hierarchy structure. For more information, see 教學課程：使用 hierarchyid 資料類型 | |
| 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. | |
| Time | Time object returns values for any valid time of day based on a 24 hour clock between '00:00:00' and max '23:59:59:9999999'. | |
| 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. | |
| UserDefinedTableType | A SQL Server common language runtime (CLR) user-defined table type. | |
| UserDefinedType | A SQL Server 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 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.