在Select 语句中添加一个记录号的字段

  -- sql server 2005
select 记录号 = row_number() over ( order by id) , * from tb
select 记录号 = row_number() over ( order by id desc ) , * from tb

-- sql server 2000
select 记录号 = ( select count ( 1 ) from tb where id < t.id) + 1 from tb t
select 记录号 = ( select count ( 1 ) from tb where id > t.id) + 1 from tb t

select * , 记录号 = identity ( int , 1 , 1 ) into tmp from tb
select * from tmp