For an example of parameterized orderby clause:

CREATE PROCEDURE sp_ParameterizedOrderBy @orderby VARCHAR(25)

AS

BEGIN

SELECT *

FROM information_schema.columns

ORDER BY CASE @orderby

...

For a parameterized order by clause:

CREATE PROCEDURE sp_ParameterizedOrderBy @orderby VARCHAR(25)

AS

BEGIN

SELECT *

FROM information_schema.columns

ORDER BY CASE @orderby

...

Not brand new technique, but useful indeed.

Same approach can also be used to parametrize the order by clause...