Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

XML Data Types (XMLA)

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

In addition to the standard primitive and derived types defined by the XML 1.0 recommendation, the XML for Analysis (XMLA) 1.1 specification defines additional data types to support the representation of multidimensional and tabular data.

XMLA uses the data types listed in the following table.

Data types



The standard XML boolean data type.


The standard XML decimal data type.


A namespace on the root element. This namespace is returned when an XMLA command does not return a result because either the XMLA command does not normally return a result or because an error occurred on the Microsoft SQL Server Analysis Services instance while executing the XMLA command.


A set of named string constants for a given enumerator.


The standard XML int data type.


Multidimensional data returned by the Result parameter of the Execute method.


A self-describing XML result set returned by the Execute method.


Rows from a data source, structured by an embedded XML schema, returned by the Discover method.


The XML string data type.


The XML unsignedInt schema type.

For complete descriptions of the standard XML data types, see the World Wide Web Consortium (WC3) candidate recommendation.

Community Additions

© 2015 Microsoft