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
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
扫一扫
6470
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
