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