declare @id int,@qty intdeclare curA cursor
for
select id,qty from table1
for updateopen curAfetch next from curA into @id,@qty
update table1 set qty=50 where current of curA
select @id,50close curA
for
select id,qty from table1
for updateopen curAfetch next from curA into @id,@qty
update table1 set qty=50 where current of curA
select @id,50close curA
用fetch next只能取得下一行的记录,我想再fetch当前行一次,行不行,如果可以,用什么语句呢?