How Do I Throttle Query Results?

The default maximum row count is 5,000. If you want to throttle the number of rows that you return in a single query, you can do one of the following:

• Use the SET statement to specify the RowCount to a specific number of rows.
• Use the TOP predicate to specify the top number or top percentage of rows that you want to return.
• Use the MaxRecords property on the recordset object in ADO.