sqlserver编号

select ROW_NUMBER() OVER (ORDER BY 字段 DESC) AS rid,* 
from 表名