如何给查询出的SQL记录添加序号列

Answer 1

--row_number() over(order by ……)

select ROW_NUMBER() over(order by name) as 序号,* from sys.all_objects