共用方式為


CommandType Element (RDL)

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

語法

<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

備註

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.

請參閱

參考

Report Definition XML Elements
CommandText Element (RDL)

說明及資訊

取得 SQL Server 2005 協助