Can I pass a sort expression into a store procedure as a parameter? I
want to do sth like the following but do not know if it's possible.
Maybe I need some tricks to work around?

CREATE Procedure SelectAllRoles
(
@SortExpression varchar(20)
)
AS

IF @SortExpression <> ''
THEN

SELECT Id, Name, Name2, LastUpdated
FROM [Role]
ORDER BY @SortExpression

ELSE

SELECT Id, Name, Name2, LastUpdated
FROM [Role]

GO


Thanks!
Zhu Ming

http://www.sommarskog.se/dynamic_sql.html#Order_by

Simon