The Varigence company brand logo
Products
BimlFlexBimlStudioBimlExpress
Pricing
Solutions
IndustriesUse Cases
Resources
DocumentationKnowledge BaseBlog
About
CompanyContact Us
Products
BimlFlexBimlStudioBimlExpress
Pricing
Solutions
IndustriesUse Cases
Resources
DocumentationKnowledge BaseBlog
About
CompanyContact Us
Schedule Demo
Account
Schedule Demo
Account

SsasDataType Enumeration

The SsasDataType enumeration provides a collection of data types supported by SQL Server Analysis Services.

Enumeration Values

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

© Varigence