i havent done this very long time..may not work..

update table_name
set order_id = (select max(order_id) from table_name) + 1
where order_id = 0;

also lots of other ways...

所有跟帖： 

• 我查过SQL Reference了，这应该是可行的。。 -PantyM- ♂ (115 bytes) () 05/04/2006 postreply 21:42:09