SqlNumOrders%

Returns the number of columns specified in the ORDER BY clause of a Transact-SQL SELECT statement.

Syntax

SqlNumOrders% ( sqlconn% )

where

sqlconn%

Is a SQL Server connection. The value of sqlconn% is returned by SqlOpen%.

Returns

The number of ORDER BY columns.

Remarks

Once a SELECT statement is executed and SqlResults% returns SUCCEED, call SqlNumOrders% to find out how many columns are specified in the current statement's ORDER BY clause.

See Also

SqlOrderCol%, SqlResults%