sqlserver 的一个有游标的过程
//遍历 while @@fetch_status=0 Begin//更新数据 update STUDENT set IDENTY_NUM=@IDENTY_NUM,EXAM_NUM=@EXAM_NUM where student_num=@STUDENT_NUM//取下一个数据 fetch c_emp into @IDENTY_NUM,@EXAM_NUM,@STUDENT_NUM Endclose c_emp
?
发布时间: 2012-08-10 12:19:33 作者: rapoo
sqlserver 的一个有游标的过程
//遍历 while @@fetch_status=0 Begin//更新数据 update STUDENT set IDENTY_NUM=@IDENTY_NUM,EXAM_NUM=@EXAM_NUM where student_num=@STUDENT_NUM//取下一个数据 fetch c_emp into @IDENTY_NUM,@EXAM_NUM,@STUDENT_NUM Endclose c_emp
?