--sql2000
select IDENTITY(int,1,1) as id,* into # from TableName
select * from #
--sql2005
select ROW_NUMBER()over(order by getdate()) as rn ,FieldName
From TableName
--sql2000
select IDENTITY(int,1,1) as id,* into # from TableName
select * from #
--sql2005
select ROW_NUMBER()over(order by getdate()) as rn ,FieldName
From TableName