游标

--SELECT * FROM Students

declare mycursor cursor for
select * from Students

open mycursor
declare @Id int, @Name nvarchar(20), @Age int, @Sex bit, @Flag bit;
fetch next from mycursor into @id,@name,@age,@sex,@flag    

while @@FETCH_STATUS = 0
begin    
    select @Id,@name
    fetch next from mycursor into @id,@name,@age,@sex,@flag    
end
close mycursor

deallocate mycursor