SQLServer 添加序号列

select ROW_NUMBER()OVER(ORDER BY 用来排序的列的列名),XXX,XXX from XXX

?