-- 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

--------------------

declare @databaseName varchar(255)
-- Collect the names of the Databases
-- and insert them into a temp Database table
select name into #tempDatabaselist from sysdatabases

declare database_cursor cursor for select * from #tempDatabaseList

open database_cursor
fetch next from database_cursor into @databaseName
	IF @@FETCH_STATUS <> 0 
	PRINT '         <<None>>'     

	WHILE @@FETCH_STATUS = 0
	BEGIN

		print @databaseName
		FETCH NEXT FROM database_cursor INTO @databaseName

	END

CLOSE database_cursor
DEALLOCATE database_cursor
drop table #tempDatabaselist