-- Simple Cursor

DECLARE vend_cursor CURSOR
FOR SELECT * FROM Purchasing.Vendor
OPEN vend_cursor
FETCH NEXT FROM vend_cursor

-- Simple Cursor with values

DECLARE vend_cursor CURSOR
FOR SELECT VendorID, Name FROM Purchasing.Vendor WHERE PreferredVendorStatus = 1 ORDER BY VendorID

OPEN vend_cursor
FETCH NEXT FROM vendor_cursor 
INTO @vendor_id, @vendor_name
WHILE @@FETCH_STATUS = 0
BEGIN

END
FETCH NEXT FROM vendor_cursor 
INTO @vendor_id, @vendor_name
END 
CLOSE vendor_cursor
DEALLOCATE vendor_cursor