根据用户参数按不同的列排序的ORDER BY写法

武林三粗

1. create procedure order_exam
   
2. @orderbyCol int
   
3. as
   
4.   select a, b, c, d
   
5.   from test
   
6.   order by case @orderbyCol when 1 then a when 2 then b when 3 then c when 4 then d else a end
   

复制代码