日期:2014-05-17 浏览次数:20583 次
declare enumcursor cursor scroll
for select * from t_enum where ID in (select * from lot.dbo.rlotclum()) order by id
for update
open enumcursor
fetch next from enumcursor
while @@fetch_status = 0
begin
update lot.dbo.t_enum set [ball] = 2 where CURRENT of enumcursor
fetch next from enumcursor
end
close enumcursor
deallocate enumcursor
select * from dbo.t_enum