use northwind
declare allcontacts CURSOR
KEYSET
FOR
SELECT CompanyName, ContactName,ContactTitle
FROM Customers
GO
OPEN AllContacts
PRINT 'The cursor contains '+CONVERT(char(3),@@CURSOR_ROWS)+ ' rows'
DECLARE @Company varchar(40)
DECLARE @Contact varchar(40)
DECLARE @Title varchar(40)
FETCH FIRST FROM allcontacts
INTO @Company, @Contact, @Title
WHILE @@FETCH_STATUS=0
BEGIN
Print Convert(char(30),@Company) +
Convert(char(25),@Contact) +
Convert(char(20),@Title)
FETCH NEXT FROM allcontacts INTO
@Company, @Contact, @Title
END
CLOSE allcontacts
DEALLOCATE allcontacts