如果记录中,增加一个自增列,就可以:
alter table tablename(
iid int identity(1,1))delete tablename where iid = ...insert tablename values ...
alter table tablename(
iid int identity(1,1))delete tablename where iid = ...insert tablename values ...
alter table tablename(
iid int identity(1,1))delete tablename where iid = ...insert tablename values ...select * from tablename order by iid
我已经是第二次看到别人问这个问题了,
简直受不了。。 真是···!!!