6、游标

1、游标
use Xk
go
declare mycursor cursor for select Top 5 ClassNo,ClassName from Class
open mycursor
fetch next from mycursor
while @@fetch_status=0
begin 
fetch next from mycursor
end
close mycursor
deallocate mycursor






update seller set sex='女' where current of mycursor


delete from seller where current of mycursor