CommandType Element (RDL)
Indicates the type of query that is contained in the CommandText element.
Sintaxis
<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 |
|
Child element |
None |
Notas
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. |
Vea también
Referencia
Report Definition XML Elements
CommandText Element (RDL)