| title | SQLFetchScroll | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 03/17/2017 | |
| ms.prod | sql-server-2016 | |
| ms.reviewer | ||
| ms.suite | ||
| ms.technology |
|
|
| ms.tgt_pltfrm | ||
| ms.topic | reference | |
| apitype | DLLExport | |
| helpviewer_keywords |
|
|
| ms.assetid | 524a3985-a08d-4445-99e0-bb551a666615 | |
| caps.latest.revision | 35 | |
| author | JennieHubbard | |
| ms.author | jhubbard | |
| manager | jhubbard |
[!INCLUDESNAC_Deprecated]
SQLFetchScroll returns one row set of data to the application. The size of the row set is set using SQLSetStmtAttr. The [!INCLUDEssNoVersion] Native Client ODBC driver supports all defined fetch instructions (for example, SQL_FETCH_RELATIVE) with the following limitations:
-
If a forward-only cursor is defined for the statement, SQL_FETCH_NEXT is required and attempts to fetch in any other fashion will result in an error return.
-
SQL_FETCH_BOOKMARK is supported for static and keyset-driven cursors only.
Result column values of date/time types are converted as described in Conversions from SQL to C.
For more information, see Date and Time Improvements (ODBC).
SQLFetchScroll supports large CLR user-defined types (UDTs). For more information, see Large CLR User-Defined Types (ODBC).