使用游标修改数据表的方法SQL2005:
举例:
declare up_cur cursor scroll for
select au_id ,au_lname,au_fname,phone from authors for update of au_lname
open up_cur
declare @row int
set @row =6
fetch absolute @row from up_cur
update authors set au_lname ='Mr' where current of up_cur
close up_cur
deallocate up_cur
--------------------------