资源描述：
《数据库教学资料实验及答案17》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。
1、实验十七游标1.创建游标curl,使curl可以对student表所有的数据行进行操作，然后打开该游标,输出游标中行数declarecurlcursorforselect*fromstudentopencurlprint0@cursor_rowsclosecurldeallocatecurl2.创建游标cur2,逐行显示在消息。1001100210031004100510061007100810091010烏消息高等数学英需信息系统操作系统数据结构3亘g语言哲学.电直会计力学declarecur2cursorforselecte
2、no,cname,ccreditfromcourseforreadonlyopencur2declare@cnochar(4),Renamenvarchar(25),Accredittinyintfetchnextfromcur2into@cno,Rename,Accreditwhile@@FETCH_STATUS=Obeginprint@cno+'1+@cname+'1+convert(char(2),Accredit)fetchnextfromcur2into@cno,Rename,Accreditendclosecur2d
3、eallocatecur23•使用fetch返回指定行数据。nextFirst,last,prior.absolute5,relativeFirstdeclarecur3cursorscrollforselect*fromstudentopencur3fetchnextfromcur3fetchfirstfromcur3fetchlastfromcur3fetchpriorfromcur3fetchabsolute5fromcur3fetchrelative-2fromcur3fetchfirstfromcur3closecur
4、3deallocatecur34•用游标修改数据，是少数民族的，高考分数加10分。declarecur4cursorforselectsname,scomegrade,snationfromstudentdeclare@xmnvarchar(4),@gkcjint,@mzbitopencur4fetchnextfromcur4into@xm,@gkcj,@mzwhile@@FETCH_STATUS=Obeginif(@mz=l)updatestudentsetscomegrade=scomegrade+10wherecurren
5、tofcur4fetchnextfromcur4into@xm,@gkcj,@mzendclosecur4deallocatecur45•用游标删除数据，删除是少数民族的记录。declarecur5cursorforselectsname,scomegrade,snationfromstudentdeclare@xmnvarchar(4),@gkcjint,@mzbitopencur5fetchnextfromcur5into@xm，@gkcj,@mzwhile@@FETCH_STATUS=Obeginif(@mz=l)dele
6、testudentwherecurrentofcur5fetchnextfromcur5into@xm,@gkcj,@mzendclosecur5deallocatecur56.使用游标变量打开student表,并显示所有学生姓名及入学成绩。declarecur6cursorforselectsname,scomegradefromstudentdeclare@xmnvarchar(4),@gkcjintopencur6fetchnextfromcur6into@xm,@gkcjwhile@@FETCH_STATUS=Obegi
7、nprint@xm+11+convert(char,@gkcj)fetchnextfromcur6into@xm,@gkcjendclosecur6deallocatecur67•在一个游标里使用另一个游标，逐条读出各系学生名单。selectdistinctsdeptintostudent2fromstudentdeclarecur7cursorforselectsdeptfromstudent2declare@xbnvarchar(10)opencur7fetchnextfromcur7into@xbwhile@@FETCH_
8、STATUS=0beginprint@xb+,学生名单八declarecur8cursorforselectsnamefromstudentwheresdept=@xbdeclare@xmnvarchar(4)opencur8fetchnextfromcur8i
