用SELECT語法產生序號方式
在SQL2000以前SELECT沒有產生序號功能，要產生序號都要費一番功夫，但在2005以後提供了自動序號的語法，省了不少麻煩。
官方參考網址：
http://technet.microsoft.com/zh-tw/library/ms186734.aspx
SQL2005以後版本範例：
SELECT ROW_NUMBER() OVER (ORDER BY CustomerID) AS SNO, CustomerID, CompanyName
FROM Customers
ORDER BY CustomerID
SQL2000要另外加工：
SELECT (SELECT COUNT(1) FROM Customers WHERE CustomerID <= C.CustomerID) AS SNO, C.CustomerID, C.CompanyName
FROM Customers AS C
ORDER BY C.CustomerID
官方參考網址：
http://technet.microsoft.com/zh-tw/library/ms186734.aspx
SQL2005以後版本範例：
SELECT ROW_NUMBER() OVER (ORDER BY CustomerID) AS SNO, CustomerID, CompanyName
FROM Customers
ORDER BY CustomerID
SQL2000要另外加工：
SELECT (SELECT COUNT(1) FROM Customers WHERE CustomerID <= C.CustomerID) AS SNO, C.CustomerID, C.CompanyName
FROM Customers AS C
ORDER BY C.CustomerID
