1:没有主键的情形：
Select identity(int,1,1) as iid,* into #tmp from TableName
Select * from #tmp
Drop table #tmp
2:有主键的情形：
Select (Select sum(1) from TableName where KeyField <= a.KeyField) as iid,* from TableName a order by iid
Select identity(int,1,1) as iid,* into #tmp from TableName
Select * from #tmp
Drop table #tmp
2:有主键的情形：
Select (Select sum(1) from TableName where KeyField <= a.KeyField) as iid,* from TableName a order by iid
本文转自94cool博客园博客，原文链接：http://www.cnblogs.com/94cool/archive/2011/08/03/2126007.html，如需转载请自行联系原作者
