SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2012
Product Documentation
Microsoft JDBC Driver 4.0 for SQL Server
JDBC Driver API Reference
SQLServerStatement Class
SQLServerStatement Methods
addBatch Method (SQLServerStatement)
cancel Method (SQLServerStatement)
clearBatch Method (SQLServerStatement)
clearWarnings Method (SQLServerStatement)
close Method (SQLServerStatement)
execute Method (SQLServerStatement)
executeBatch Method (SQLServerStatement)
executeQuery Method (SQLServerStatement)
executeUpdate Method (SQLServerStatement)
getConnection Method (SQLServerStatement)
getFetchDirection Method (SQLServerStatement)
getFetchSize Method (SQLServerStatement)
getGeneratedKeys Method (SQLServerStatement)
getMaxFieldSize Method (SQLServerStatement)
getMaxRows Method (SQLServerStatement)
getMoreResults Method (SQLServerStatement)
getQueryTimeout Method (SQLServerStatement)
getResponseBuffering Method (SQLServerStatement)
getResultSet Method (SQLServerStatement)
getResultSetConcurrency Method (SQLServerStatement)
getResultSetHoldability Method (SQLServerStatement)
getResultSetType Method (SQLServerStatement)
getUpdateCount Method (SQLServerStatement)
getWarnings Method (SQLServerStatement)
isClosed Method (SQLServerStatement)
isPoolable Method (SQLServerStatement)
isWrapperFor Method (SQLServerStatement)
setCursorName Method (SQLServerStatement)
setDateTimeOffset(int, java.sql.DateTimeOffset) (SQLServerStatement)
setEscapeProcessing Method (SQLServerStatement)
setFetchDirection Method (SQLServerStatement)
setFetchSize Method (SQLServerStatement)
setMaxFieldSize Method (SQLServerStatement)
setMaxRows Method (SQLServerStatement)
setPoolable Method (SQLServerStatement)
setResponseBuffering Method (SQLServerStatement)
setQueryTimeout Method (SQLServerStatement)
unwrap Method (SQLServerStatement)
Expand Minimize
This topic has not yet been rated - Rate this topic

getMaxRows Method (SQLServerStatement)

SQL Server 2012

Retrieves the maximum number of rows that a SQLServerResultSet object that is produced by this SQLServerStatement object can contain.

Copy 

public final int getMaxRows()

An int that indicates the maximum number of rows, or 0 if there is no limit.

This getMaxRows method is specified by the getMaxRows method in the java.sql.Statement interface.

This getMaxRows method always returns 0 for dynamic scrollable cursors.

Did you find this helpful?
(1500 characters remaining)
© 2013 Microsoft. All rights reserved.