是不是由于表中的列 过多的原因?? 单加 ID列的话 就是完全正确的 select identity(int,1,1)as ID into #vDlvrPickGoods from vDlvrPickGoods select * from #vDlvrPickGoods drop table #vDlvrPickGoods 把后面的列 加上去 到 第11个列 就会混乱 求高手解决下!!
--TRY select identity(int,1,1)as ID,VBELN,POSNR,TRANS_ID,VRKME,BarCode,WorkSheet,BobbinsNO,SO,POS,MatType,LOT_NO,ProdSpec,PLANT,BF,GRADE,SGRADE,LINE,MF,DMP,ProductMF,PackType,NetWT,GrossWT,Yards,NumOfBobbins,ProductDate,LableDate,StateCode,UserID,CheckID,CreateTime,LastModify,History,stockposition into #vDlvrPickGoods from vDlvrPickGoods select * from #vDlvrPickGoods order by ID asc drop table #vDlvrPickGoods
select * from #vDlvrPickGoods order by ID
暂时不知道是什么原因!
select identity(int,1,1)as ID into #vDlvrPickGoods from vDlvrPickGoods
select * from #vDlvrPickGoods
drop table #vDlvrPickGoods
把后面的列 加上去 到 第11个列 就会混乱
求高手解决下!!
select identity(int,1,1)as ID,VBELN,POSNR,TRANS_ID,VRKME,BarCode,WorkSheet,BobbinsNO,SO,POS,MatType,LOT_NO,ProdSpec,PLANT,BF,GRADE,SGRADE,LINE,MF,DMP,ProductMF,PackType,NetWT,GrossWT,Yards,NumOfBobbins,ProductDate,LableDate,StateCode,UserID,CheckID,CreateTime,LastModify,History,stockposition into #vDlvrPickGoods from vDlvrPickGoods
select * from #vDlvrPickGoods order by ID asc
drop table #vDlvrPickGoods