你可以试试这个
SELECt * FROM ProductsORDER BY CASE WHEN @SortIndex = 1 THEN Price END ASC,CASE WHEN @SortIndex = 2 THEN Price END DESC, CASE WHEN @SortIndex = 2 THEN Title END ASC

你可以试试这个
SELECt * FROM ProductsORDER BY CASE WHEN @SortIndex = 1 THEN Price END ASC,CASE WHEN @SortIndex = 2 THEN Price END DESC, CASE WHEN @SortIndex = 2 THEN Title END ASC