Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 |
|
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)