| title | SQLFetchScroll | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 03/17/2017 | |
| ms.prod | sql | |
| ms.prod_service | database-engine, sql-database, sql-data-warehouse, pdw | |
| ms.reviewer | ||
| ms.technology | native-client | |
| ms.topic | reference | |
| apitype | DLLExport | |
| helpviewer_keywords |
|
|
| ms.assetid | 524a3985-a08d-4445-99e0-bb551a666615 | |
| author | markingmyname | |
| ms.author | maghan | |
| monikerRange | >=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current |
[!INCLUDEappliesto-ss-asdb-asdw-pdw-md]
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).