在没有Sql Server 2000中加入 记录编号

如题:

Select IdEntity(int,1,1) as [id],* Into #t From TableName

Select * From #T

Drop Table #T