You can select which column to sort a SELECT statement by at runtime, using just one parameter. To do this, declare one parameter and use it with a CASE command. Then, include each column you might want to sort by as a CASE condition, for example:
Declare @Parameter char(1)SELECT ID, Descripcion, Stock, Price Case @Parameter when 'I' then ID when 'D' then Descripcion when 'S' then Stock when 'P' then Price END AS SortColumnFROM ProductsORDER BY SortColumnUsing this method, you can avoid writing if clauses for each possible sort order.
