怎样获取查询中纪录行的序列号

[fifa]

怎样获取查询中纪录行的序列号？
我不知道SqlServer有没有提供类似
RowIndex()的函数，请高人指点

[saucer]

SELECT @@IDENTITY as 'ID"

or

SELECT SCOPE_IDENTITY() as 'ID'

[saucer]

sorry, SQL Server doesn't support that feature, you need to simulate it:

select identity(int,1,1) as id, * into #temp from pubs..authors

select * from #temp

[伍子V5]

select(select sum(1) from table where pkcolumn<=a.pkcolumn) as rowid,* from table a

[生活真美好]

gz

[xutaohuang]

select identity(int,1,1) as id, * into #temp from pubs..authors

select * from #temp

[pengdali]

select (select sum(1) from 你的表 where 主键<=tem.主键) row,* from 你的表 tem