Murach's SQL Server 2005 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 2005 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 448
An introduction to cursors 448
The seven types of SQL Server cursors 450
SQL statements for cursor processing 452
How to use cursors to retrieve data 454
How to declare a cursor 454
How to retrieve a row using a cursor 456
How to use the @@FETCH_STATUS system function 458
How to use the @@CURSOR_ROWS system function 460
How to modify data through a cursor 462
How to use the cursor concurrency options 462
How to update or delete data through a cursor 464
Additional cursor processing techniques 466
How to use cursors with dynamic SQL 466
How to code Transact-SQL cursors for use by an application program 468
Perspective 470
t


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

Murach's SQL Server 2005 - sql cursors

Learn more about this book

View the table of contents

Add this book to your cart



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.