Sybase Technical Library - Product Manuals Home
[Search Forms] [Previous Section with Hits] [Next Section with Hits] [Clear Search] Expand Search
New Security Features [Table of Contents] Data Definition Enhancements

What's New in SYBASE SQL Server Release 10.0?

[-] Chapter 1: New Features in SQL Server Release 10.0
[-] Cursors

Cursors

SQL Server Release 10.0 provides full support for cursors. The following cursor commands are documented in Volume 1 of the SQL Server Reference Manual :

declare cursor
fetch
open
close
deallocate

A new topic called "Cursors" in Volume 1 of the SQL Server Reference Manual provides an overview of cursors. New keywords that allow updating and deleting at cursor positions are described on the delete and update pages. A new set option controls the number of rows returned by a fetch command. A new system procedure, sp_cursorinfo , provides information about the active cursors in a database.

Chapter 15, "Cursors: Accessing Data Row by Row" , in the Transact-SQL User's Guide provides examples of cursor use, including cursors in stored procedures.

New Security Features [Table of Contents] Data Definition Enhancements