Updating the fetched cursor record in a stored prodecure

[FrankA]

When looping through a cursor in a stored procedure, can the currently fetched
record be updated or do I need to issue an update statement on the table?
If the cursor can be updated how is it done? Thanks for any help provided!!

[David Satz]

I have never wanted to / found a need to do this, but in BOL it says you
would need to
DECLARE cursor_name CURSOR
FOR select_statement
[ FOR UPDATE [ OF column_name [ ,...n ] ] ]

and then update using

UPDATE
{
table_name WITH ( < table_hint_limited > [ ...n ] )
| view_name
| rowset_function_limited
}
SET
{ column_name = { expression | DEFAULT | NULL }
| @variable = expression
| @variable = column = expression } [ ,...n ]

{ { [ FROM { < table_source > } [ ,...n ] ]

[ WHERE
< search_condition > ] }
|
[ WHERE CURRENT OF
{ { [ GLOBAL ] cursor_name } | cursor_variable_name }

--
HTH,
David Satz
Principal Web Engineer
Hyperion Solutions

"FrankA" <Frank.Ansanitis@bhs.org> wrote in message
news:3ddbdddd$1@tnews.web.devx.com...
>
> When looping through a cursor in a stored procedure, can the currently
fetched
> record be updated or do I need to issue an update statement on the table?
> If the cursor can be updated how is it done? Thanks for any help
provided!!
>