sql server 表中id的重新排列如何使表中id按增序排列,id是自设的,现在是乱的,如何写sql语句?[解决办法]select * into # from tb order by id truncate table tb insert into tb select * from # drop table #