75. ID重新走过，备份表

select * into ML_QuoteApply_InPro_bak20150629 from ML_QuoteApply_InPro

truncate table ML_QuoteApply_InPro

select identity(int,1,1) id,Product,MatCode,Name,Class,Price,ActualPrice,Num,RePrice,ReBate,ReMoney,Money,FootPrice,FootMoney,System,Type,Remark,ML_QuoteApply_ID
into #temp_InPro
from ML_QuoteApply_InPro_bak20150629

insert into ML_QuoteApply_InPro(id,Product,MatCode,Name,Class,Price,ActualPrice,Num,RePrice,ReBate,ReMoney,Money,FootPrice,FootMoney,System,Type,Remark,ML_QuoteApply_ID)
select id,Product,MatCode,Name,Class,Price,ActualPrice,Num,RePrice,ReBate,ReMoney,Money,FootPrice,FootMoney,System,Type,Remark,ML_QuoteApply_ID
from #temp_InPro

select * from ML_QuoteApply_InPro order by id 

drop table #temp_InPro