Sql Server Cursor Sample

sql-cursor-sample.sql

Use Northwind
Go

Declare @CatId Int, @CatName NvarChar(50)

Declare catCur Cursor For
    Select c.CategoryId, c.CategoryName From Categories c
Open catCur
Fetch Next From catCur InTo @CatId, @CatName

While (@@FETCH_STATUS = 0)
Begin
    -- do some thing
    Print @CatId
    Print @CatName
    Fetch Next From catCur InTo @CatId, @CatName
End


Close catCur
Deallocate catCur