get_table_data
Retrieve paginated records from SQL Server tables to access specific data pages while managing result volume efficiently.
Instructions
Get paginated data from a SQL Server table. Returns a specified page of records with pagination enforced.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | The name of the table to query (can include schema, e.g., 'dbo.Users') | |
| page | No | Page number (1-based). Defaults to 1. | |
| pageSize | No | Number of records per page. Must be between 1 and 1000. Defaults to 100. | |
| orderBy | No | Column name to order by. Defaults to first column if not specified. |