通过SELECT进行多列动态订购

江国龙

当ORDER BY基于CASE语句时，选择多个ORDER BY列的正确MS SQL语法是什么？
9 @4 M! @: x  {以下对于单列工作正常，但我需要按多列进行排序：
SELECT * FROM Products
$ K# E' N2 o# Y0 c& t" YORDER BY
CASE WHEN @SortIndex = 1 THEN Price END ASC,
CASE WHEN @SortIndex = 2 THEN Price DESC, Title ASC END 你可以试试这个
+ z1 W- M8 k4 N3 XSELECT * FROM Products
" S+ S& Y; V) C; o% P* x, T3 UORDER BY
) M- q  W9 h+ K1 Q2 w7 e1 |6 ]3 t8 ?CASE WHEN @SortIndex = 1 THEN Price END ASC,
$ ?; G- ~4 h7 vCASE WHEN @SortIndex = 2 THEN Price END DESC,
- F* G2 O/ {+ y1 NCASE WHEN @SortIndex = 2 THEN Title END ASC