select出来的表增加递增列

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