用游标搞定:declare @min intdeclare @max intdeclare cur cursor for select ID from QIDopen curdeclare @id intfetch cur into @idwhile(@@fetch_status=0)beginSELECT @min=底界,@max=顶界 from QID where id=@idUPDATE 量级=量级+1 WHERE FF>@min AND FFcu.底界;
commit;
end loop;end;...