Share via


CommandType Element (RDL)

Indicates the type of query that is contained in the CommandText element.

Syntax

<Query>
    ...
    <CommandType>...</CommandType>
    ...
</Query>

Element Characteristics

Characteristic Description

Data type and length

String

Default value

Text

Cardinality

0-1: Optional element that can occur once or not at all.

Element Relationships

Relationship Element

Parent element

Query

Child element

None

Remarks

The value for the CommandType element is restricted to one of the following strings.

Value Description

Text

Indicates that the value is a text string to pass to the data source, for example, a Transact-SQL query.

StoredProcedure

Indicates that the value is the name of a stored procedure to execute. The stored procedure must return a single result set.

TableDirect

Indicates that the value is the name of a table from which to retrieve data. All data from the table is returned.

See Also

Reference

Report Definition XML Elements
CommandText Element (RDL)

Help and Information

Getting SQL Server 2005 Assistance