select出来的表增加递增列

Select identity(int,1,1) as no,* into #tmp from table

  

原文地址:https://www.cnblogs.com/zhoushiya/p/12107477.html