MAX_SELECT_ROWS
- Description:
-
This parameter allows you to limit the amount of SQL database table rows retrieved from the server prior to looping through the result set. This parameter applies to large tables specified in the maxSelectRowSources folder located at /database/sqlserver/.
You can specify the number of rows you want retrieved starting at the top of the table. Use “Top nnn” to specify the number of rows to be retrieved. For example, “Top 100” would tell the system to retrieve the top 100 rows.
- Valid Values:
-
Top nnn, where nnn denotes the number of rows you want retrieved.
- Default Value:
-
0
- Location:
-
/database/sqlserver
- Effective:
-
Workbrain 5.0.2.1 (Fixpack 24)