Export (0) Print
Expand All
Expand Minimize

CommandType Element (RDL)

SQL Server 2005

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


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

Characteristic Description

Data type and length

String

Default value

Text

Cardinality

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

Relationship Element

Parent element

Query

Child element

None

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.

Community Additions

ADD
Show:
© 2014 Microsoft