Murach's SQL Server 2008 for Developers
How to work with cursors

A sql cursor lets you retrieve data from a result set one row at a time. In this chapter, you'll learn about the different types of sql cursors that you can use with a SQL Server 2008 database. You'll also learn about the Transact-SQL statements for working with cursors.
Chapter 15 How to work with cursors
How to use cursors in SQL Server 480
An introduction to cursors 480
The seven types of SQL Server cursors 482
SQL statements for cursor processing 484
How to use cursors to retrieve data 486
How to declare a cursor 486
How to retrieve a row using a cursor 488
How to use the @@FETCH_STATUS system function 490
How to use the @@CURSOR_ROWS system function 492
How to modify data through a cursor 494
How to use the cursor concurrency options 494
How to update or delete data through a cursor 496
Additional cursor processing techniques 498
How to use cursors with dynamic SQL 498
How to code Transact-SQL cursors for use by an application program 500
t


© Copyright 1998- Mike Murach & Associates, Inc.  All rights reserved.

Murach's SQL Server 2008 - sql cursors

Learn more about this book

View the table of contents


More about the eBook



Our Ironclad Guarantee

First, try our books for 90 days. Then, if you aren't completely convinced that our books are the best ones you've ever used, you can return them for a full refund...no questions asked.