DEALLOCATE c_emp //删除现有的同名游标//声明一个游标 c_empdeclare c_emp cursor for select NEWSTUDENT.IDENTY_NUM,NEWSTUDENT.EXAM_NUM,NEWSTUDENT.STUDENT_NUM from NEWSTUDENT,STUDENT where NEWSTUDENT.STUDENT_NUM=STUDENT.STUDENT_NUM//声明三个变量declare @IDENTY_NUM nchar(20),@EXAM_NUM nchar(30),@STUDENT_NUM nchar(15)//打开游标 open c_emp//取出数据 fetch c_emp into @IDENTY_NUM,@EXAM_NUM,@STUDENT_NUM
//遍历 while @@fetch_status=0 Begin//更新数据 update STUDENT set [email protected]_NUM,[email protected]_NUM where [email protected]_NUM//取下一个数据 fetch c_emp into @IDENTY_NUM,@EXAM_NUM,@STUDENT_NUM Endclose c_emp
?