Beginning T-SQL with Microsoft® SQL Server® 2005 and 2008 by Paul Turley & Dan Wood

Author:Paul Turley & Dan Wood
Language: eng
Format: epub
Publisher: John Wiley & Sons
Published: 2010-12-21T16:00:00+00:00

To create a cursor that allows updates only to and from the Name column of the Product table, declare the cursor like this:

DECLARE curProduct CURSOR FOR SELECT ProductID, Name

FROM Production.Product

FOR UPDATE OF Name

The cursor isn’t actually populated until it is opened. Executing the OPEN command loads the cursor structure and data into memory:

OPEN curProduct

At this point, the record pointer is positioned before the first row. The FETCH NEXT command navigates the pointer to the next record and returns a comma-delimited list of column values. In this case, the pointer is moved to the first row. Individual variables can be used to capture the values of the current row’s column values:

DECLARE @ProdID Int

DECLARE @ProdName VarChar(100)

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.