日期:2014-05-17 浏览次数:20485 次
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