sqlserver得到行号

select * from O_OrderWovenLabel

select row_number()over(order by Size )as RowNum,*from O_OrderWovenLabel

ROW_NUMBER() OVER (ORDER BY id desc)为SQL2005新增函数，表示取出每一列的行号