更改为此:
SELECt TOP 10 * FROM TBL_LMS_USERS_RECORDs_LAST_ATTEMPTORDER BY CASE WHEN @OrderBy = 1 THEN s10_record_dow ELSE NUll END, CASE WHEN @OrderBy = 2 THEN pk_big_record_id ELSE NULL END, CASE WHEN @OrderBy <> 1 AND @OrderBy <> 2 THEN s10_record_dow ELSE NULL END



