SET NOCOUNT ON
DECLARE @AuthorID char(11)
DECLARE c1 CURSOR READ_ONLY
FOR SELECT au_id FROM authors
OPEN c1
FETCH NEXT FROM c1 INTO @AuthorID
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT @AuthorID /* PRINT yerine ne kullanmalıyım? */
FETCH NEXT FROM c1 INTO @AuthorID
END
CLOSE c1
DEALLOCATE c1