如何在查询数据表的同时，获得记录的序号？

[ralpher2017]

例如有数据表：users
TID Name Sex
3 aaa m
4 bbb f
如何用些select语句来获得下列结果？
XH TID Name Memo
1 3 n1 m1
2 4 n2 m2

帮忙了！

[ralpher2017]

呵呵，结果写错了，应该为：
XH TID Name Sex
1 3 aaa m
2 4 bbb f

[愉快的登山者]

select identity(int,1,1) as XH, * into #t from users
go
select * from #t order by XH
go

[愉快的登山者]

select (select count(*) from users where TID <= A.TID) as XH, * from users as A
order by TID

[yoki]

alter table users add rownum int identity(1,1)
select * from users
alter table users drop column rownum

[caiyunxia]

ALERT TABLE USER ADD ID INT IDENTITY（1，1）
SELECT * FROM USER

[yoki]

如果TID已经是标识列
那么用登山的这个方法
select (select count(*) from users where TID <= A.TID) as XH, * from users as A
order by TID

[CrazyFor]

没有主键的情况:
select identity(int,1,1) as XH, * into #t from users
go
select * from #t order by XH
go


有主键的情况:
select (select count(*) from users where TID <= A.TID) as XH, * from users as A
order by TID

[ralpher2017]

谢谢了：）