SQL Server 2000
Indicates the type of query that is contained in the CommandText element.
|Data type and length||String|
|Cardinality||0-1: Optional element that can occur once or not at all|
The value for the CommandType element is restricted to one of the following strings.
|Text||Indicates that the value of the CommandText element is a text string to pass to the data source, for example, a Transact-SQL query.|
|StoredProcedure||Indicates that the value of the CommandText element is the name of a stored procedure to execute. The stored procedure must return a single result set.|
|TableDirect||Indicates that the value of the CommandText element is the name of a table from which to retrieve data. All data from the table is returned.|