Tim Chapman discusses your iteration choices in SQL Server 2008 and explains why determining which option performs better depends on the situation. In a previous TechRepublic column about SQL Server ...

For forward cursors, this is fairly straightforward. For dynamic cursors it more complex when the fetch size is greater than 1. An application can move the cursor forward and backward within the ...

-- Declare a scrollable cursor named 'scroll_cursor'. -- Scrollable cursors allow movement both forward and backward through the result set. -- This cursor selects StudentID, Name, and Grade from the ...