select 包含 Row_Number

查詢所有產品編號,並加上行數!

select Row_Number() over (order by papdno) as RowNt,papdno from pm10d;

[輸出] 1 pdno1 2 pdno2 3 pdno3 . . . 10 pdno10 將行數轉為字串,並補0 select right('00'+ltrim(Row_Number() over (order by papdno)),3) as RowNt ,papdno from pm10d; [輸出] 001 pdno1 002 pdno2 003 pdno3 . . . 010 pdno10