| title | setFetchSize Method (SQLServerStatement) |
|---|---|
| description | setFetchSize Method (SQLServerStatement) |
| author | David-Engel |
| ms.author | davidengel |
| ms.date | 01/19/2017 |
| ms.service | sql |
| ms.subservice | connectivity |
| ms.topic | reference |
| apilocation | sqljdbc.jar |
| apiname | SQLServerStatement.setFetchSize |
| apitype | Assembly |
[!INCLUDEDriver_JDBC_Download]
Gives the [!INCLUDEjdbcNoVersion] a hint as to the number of rows that should be fetched from the database when more rows are needed.
public final void setFetchSize(int rows)
rows
An int that indicates the number of rows to fetch.
This setFetchSize method is specified by the setFetchSize method in the java.sql.Statement interface.