declare @book_no varchar(10)
declare @message VARCHAR(80)

declare book_cursor cursor
for select book_no from book


open book_cursor

FETCH NEXT FROM book_cursor INTO @book_no

print @book_no

IF @@FETCH_STATUS <> 0   
        PRINT '<<None>>' 


While @@FETCH_STATUS=0
begin
   select @message='book_no='+@book_no
   print @message
   FETCH NEXT FROM book_cursor INTO @book_no
end
close book_cursor;
DEALLOCATE book_cursor;