How SQL Server 2000 cursors are used

server| Cursors
How to use cursors:
Use DB1
Declare my_cursor cursor Scroll dynamic/*scroll indicates that cursor pointers can be moved at will (otherwise only forward), and dynamic means that cursors can be read or written (otherwise cursors are read-only).
For
Select name from personal data

Open My_cursor
declare @name sysname
FETCH NEXT from My_cursor into @name
while (@ @fetch_status =0)
Begin
print ' name: ' + @name
FETCH NEXT from My_cursor into @name
End
Fetch the my_cursor into @name
Print @name
/* Update personal data set name = ' Zzg ' WHERE CURRENT of my_cursor * *
/* Delete from profile WHERE CURRENT of My_cursor * *
Close My_cursor
Deallocate my_cursor
Body