declare @qk char(4)
declare cqk cursor for
select qkb.qkh from qkb,tgb where (qkm = '计算机学报' and qkb.qkh = tgb.qkh and sgjg = '未通过')
open cqk
fetch last from cqk into @qk
update tgb set sgjg = '通过' where tgb.qkh = @qk
close cqk
deallocate cqk
有段时间没用sql,语法就忘了,这个问题出现的原因很简单:
declare cqk scroll cursor for
声明游标时记得加上scroll关键字才能使用fectch last;