GitHub

fetch-status-transact-sql.md

This function returns the status of the last cursor FETCH statement issued against any cursor currently opened by the connection. :::image type="icon" source ...
GitHub

scrolling-and-fetching-rows.md

[!INCLUDE[SQL Server Azure SQL Database Synapse Analytics PDW](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw.md)] To use a scrollable cursor, an ODBC ...
The Earth Institute Columbia University

Embedded SQL Programming Guide

With static SQL, host variables used in embedded SQL statements are known at application compile time. With dynamic SQL, the embedded SQL statements and consequently the host variables are not known ...
The Earth Institute Columbia University

Call Level Interface Guide and Reference

Rowset starting on next row SQL_FETCH_RELATIVE with FetchOffset set to 1 Line Down Rowset starting on previous row SQL_FETCH_RELATIVE with FetchOffset set to -1 Line Up Rowset starting on a specific ...
TechRepublic

Comparing cursor vs. WHILE loop performance in SQL Server 2008

Tim Chapman discusses your iteration choices in SQL Server 2008 and explains why determining which option performs better depends on the situation. In a previous TechRepublic column about SQL Server ...