Ivan Uzunov Blog » Blog Archive » Set Sorting Order Column in Stored P

Changing the sorting order by passing a parameter to a stored procedure it’s a little bit tricky. The following example will return all the users form table Users (id, first_name, last_name, published_feedbacks_count, positive_feedback_percentage) in the order set by parameters @sort_column and @sort_desc.