SsasDataType Enumeration
SsasDataType Enumeration
The SsasDataType enumeration provides a collection of data types supported by SQL Server Analysis Services.
Enumeration Values
| Name | Summary |
|---|---|
| SmallInt | Specifies a 16-bit signed integer, which is equivalent to Int16 (.NET) or DBTYPE_I2 (OLE DB). |
| Integer | Specifies a 32-bit signed integer, which is equivalent to Int32 (.NET) or DBTYPE_I4 (OLE DB). |
| Single | Specifies a single precision floating point number, which is equivalent to Single (.NET) or DBTYPE_R4 (OLE DB). |
| Double | Specifies a double precision floating point number, which is equivalent to Double (.NET) or DBTYPE_R8 (OLE DB). |
| Currency | Specifies a currency value, which is equivalent to Decimal (.NET) or DBTYPE_CY (OLE DB). |
| Date | Specifies a date stored as a double, which is equivalent to DateTime (.NET) or DBTYPE_DATE (OLE DB). |
| Boolean | Specifies a boolean value, which is equivalent to Boolean (.NET) or DBTYPE_BOOL (OLE DB). |
| TinyInt | Specifies a 8-bit signed integer, which is equivalent to SByte (.NET) or DBTYPE_I1 (OLE DB). |
| UnsignedTinyInt | Specifies a 8-bit unsigned integer. |
| UnsignedSmallInt | Specifies a 16-bit unsigned integer, which is equivalent to UInt16 (.NET) or DBTYPE_UI1 (OLE DB). |
| UnsignedInt | Specifies a 32-bit signed integer, which is equivalent to UInt32 (.NET) or DBTYPE_UI4 (OLE DB). |
| BigInt | Specifies a 64-bit signed integer, which is equivalent to Int64 (.NET) or DBTYPE_I8 (OLE DB). |
| UnsignedBigInt | Specifies a 64-bit unsigned integer, which is equivalent to UInt64 (.NET) or DBTYPE_UI8 (OLE DB). |
| WChar | Specifies a unicode character string (null terminated), which is equivalent to String (.NET) or DBTYPE_WSTR (OLE DB). |
| Inherited | Specifies that the data type should be inherited from the parent object. |