results Element (XMLA)

  • Article

Contains a collection of root elements returned by the Execute method using the Batch command.

Namespace https://schemas.microsoft.com/analysisservices/2003/xmla-multipleresults

Syntax

<return>
   <results>
      <root>...</root>
   </results>
</return>

Element Characteristics

Characteristic Description

Data type and length

None

Default value

None

Cardinality

0-1: Optional element that can occur once and only once.

Element Relationships

Relationship Element

Parent elements

return

Child elements

root

Remarks

If a Batch command is executed by the Execute method, the return element contains a single results element instead of a single root element. The content of the results element depends on the settings used to run the Batch command.

For non-transactional Batch commands, the results element contains one root element for each command executed by the Batch command, whether the command completes successfully or unsuccessfully. For transactional Batch commands, the results element contains only one root element, which contains the error information for the command that failed within the Batch command.

See Also

Concepts

Properties (XMLA)

Help and Information

Getting SQL Server 2005 Assistance