資料庫查詢結果動態排序（六）：Richard Romley 多 CASE 拆分法、避免資料類型衝突與索引優化考量

ALTER PROC GetSortedShippers
    @ColName AS SYSNAME
AS
SELECT *
FROM Shippers
ORDER BY
    CASE @ColName WHEN 'ShipperID' THEN ShipperID ELSE NULL END,
    CASE @ColName WHEN 'CompanyName' THEN CompanyName ELSE NULL END,
    CASE @ColName WHEN 'Phone' THEN Phone ELSE NULL END