Cursor Programming Details (ODBC)
Choosing the correct cursor type can improve application performance. Under certain conditions, Microsoft® SQL Server™ may implicitly convert a cursor type if you execute an SQL statement not supported by the cursor type you requested.
See Also
Choosing a Cursor Type