set nocount on
Declare @id varchar(20)
DECLARE x CURSOR FOR 
   SELECT au_id from pubs..Authors order by au_id
OPEN x

FETCH NEXT FROM x INTO @id

WHILE @@FETCH_STATUS = 0
BEGIN
   select @id
   FETCH NEXT FROM x INTO @id
END

CLOSE x
DEALLOCATE x