T-SQL Cursor

gistfile1.txt

DECLARE @Id int

DECLARE TableCursor CURSOR LOCAL FAST_FORWARD FOR
    SELECT  Id
    FROM dbo.TABLENAME 
    OPEN TableCursor 

FETCH NEXT FROM TableCursor INTO @Id

WHILE @@FETCH_STATUS=0
BEGIN

    DO STUFF  

    FETCH NEXT FROM TableCursor INTO @Id
END
CLOSE TableCursor 
DEALLOCATE TableCursor 

Optimized to be specific to the connection and the cursor is optimized for in order traversal