SQL Cursor usage

gistfile1.sql

USE RedFoxAuto

DECLARE @PricelistID varchar(50), @lName varchar(50)
 
DECLARE cursorName CURSOR LOCAL SCROLL STATIC FOR
SELECT pricelistID, pricelistName FROM productPricelistNames

OPEN cursorName -- open the cursor
FETCH NEXT FROM cursorName INTO @PricelistID, @lName
WHILE @@FETCH_STATUS = 0
 
BEGIN
   PRINT @PricelistID + ' ' + @lName -- print the name
   --SELECT @PricelistID, @lName

    
FETCH NEXT FROM cursorName INTO @PricelistID, @lName
END
 
CLOSE cursorName -- close the cursor

DEALLOCATE cursorName -- Deallocate the cursor