>>Do you mean SELECT one record (row) cursors, rather than pointing to a >>specific row (in a multi-row cursor) based on its logical position relative >>to another row?
As a rule, SQL Server can work with data as a set faster than it can respond to an iterative series of commands. However, if you feel you need to work one row at a time, then a cursor's result set can be navigated with the NEXT, PRIOR, FIRST and LAST arguments of the FETCH command. Check it out in SQL Server Books on Line.
Charlie
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only