다음을 통해 공유


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 지원 받기