O'Reilly logo

Microsoft® SQL Server™ 2000 Programming by Example by Carlos Eduardo Rojas, Fernando G. Guerrero

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Types of Cursors

SQL Server 2000 supports four types of cursors:

  • Forward-only cursors can retrieve data from the first to the last row, without any other navigation capabilities.

  • Static cursors provide a snapshot of the data to navigate without being affected by other connections.

  • Dynamic cursors retrieve a dynamic result set that sees modifications to the data made from outside the cursor.

  • Keyset-driven cursors create a fixed set of rows to navigate.

Static cursors use more storage space than dynamic or keyset-driven, but SQL Server uses fewer resources to navigate the data after their creation. Static cursors provide a fixed set of data that does not detect changes made by other connections.

Dynamic cursors use little storage space, but SQL Server ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required