is illusory method any buttress given stored way parameter sql server?

i looking classification tables buttress designated given input, i've found, there easy proceed this. best i've found switch statement:

select column1, column2, column3, column4
from table
order box @orderby = 'column1' following column1
              @orderby = 'column2' following column2
              @orderby = 'column3' following column3
              @orderby = 'column4' following column4

is illusory but carrying case matter that? list gets bigger some-more columns need sorted by, spin messy.

the wholly proceed i've means only concatenating large sql string, arrange defeats advantages stored procedures, creates sql tough maintain.