通过SELECT进行多列动态订购

江国龙

当ORDER BY基于CASE语句时，选择多个ORDER BY列的正确MS SQL语法是什么？
以下对于单列工作正常，但我需要按多列进行排序：
7 X4 @6 L7 k6 {- y0 K4 ]4 E! fSELECT * FROM Products
ORDER BY
CASE WHEN @SortIndex = 1 THEN Price END ASC,
/ k. `. v1 W3 u' |6 q, K( _. b6 pCASE WHEN @SortIndex = 2 THEN Price DESC, Title ASC END 你可以试试这个
1 m3 j; W+ A' M2 P# [SELECT * FROM Products
ORDER BY
CASE WHEN @SortIndex = 1 THEN Price END ASC,
* y6 T0 X' ~; S/ `' HCASE WHEN @SortIndex = 2 THEN Price END DESC,
, o8 [8 Y2 \1 _7 u: \& M: L7 }CASE WHEN @SortIndex = 2 THEN Title END ASC