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.service: "" ms.component: "native-client-odbc-api" ms.reviewer: "" ms.suite: "sql" ms.technology:
ms.tgt_pltfrm: "" ms.topic: "reference" apitype: "DLLExport" helpviewer_keywords:
- "SQLFetchScroll function" ms.assetid: 524a3985-a08d-4445-99e0-bb551a666615 caps.latest.revision: 35 author: "MightyPen" ms.author: "genemi" manager: "craigg" ms.workload: "Inactive" monikerRange: ">= aps-pdw-2016 || = azuresqldb-current || = azure-sqldw-latest || >= sql-server-2016 || = sqlallproducts-allversions"
[!INCLUDEappliesto-ss-asdb-asdw-pdw-md] [!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).