When these options are set to their defaults at the time a SQL statement is executed, the [!INCLUDEssNoVersion] Native Client ODBC driver does not use a server cursor to implement the result set; ...

To understand how the @@FETCH_STATUS variable controls a cursor in a WHILE loop in SQL Server, let's break down the concept from first principles. A cursor is a database object that enables you to ...

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 ...