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

setFetchDirection Method (SQLServerStatement)

SQL Server 2012

Gives Microsoft JDBC Driver for SQL Server a hint as to the direction in which result set rows should be processed.

Note Note

The JDBC driver currently ignores the hint that is given by this method.
Copy 

public final void setFetchDirection(int nDir)

nDir

An int that indicates the row processing direction, which can be one of the following values:

FETCH_FORWARD

FETCH_REVERSE

FETCH_UNKNOWN

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

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