SQL205中怎样在查询的结果前添加一列序号

declare @t table(name varchar(10))

insert into @t
select 'aaa' union
select 'bbb' union
select 'ccc' union
select 'ddd' union
select 'eee' union
select 'fff' union
select 'ggg'

select row_number() over(order by name asc) id, name from @t

------------------------------
(7 个资料列受到影响)
id name
-------------------- ----------
1 aaa
2 bbb
3 ccc
4 ddd
5 eee
6 fff
7 ggg

(7 个资料列受到影响)

给查询结果添加一列序号：selectrow_number()over(orderbyid)asrowNum,*fromtableName

select (row_number() over (order by 列名 asc))rownumber,* from 表名;