我可以在变量中存储SQL Server排序顺序吗？

I have the following SQL within a stored procedure. Is there a way to remove the IF statement and pass the 'ASC'/'DESC' option as a variable?I have the following SQL within a stored proced