关于存储过程的简单问题：在子句中加入参数行吗？

[maoning]

CREATE PROCEDURE FindInEmployee (@EmployeeName char(8)) as
select @EmployeeName from 员工表 order by @EmployeeName

这样它就报错说不能在 order by 字句中加参数，到底怎么样才能在orderby子句中加入参数呢？应该怎么写呢？

[wzh1215]

CREATE PROCEDURE FindInEmployee (@EmployeeName char(8)) as
declare @Sql varchar(300)
set @Sql=('select @EmployeeName from 员工表 order by '''+ @EmployeeName +'''')
exec (@Sql)

[mjhnet]

CREATE PROCEDURE FindInEmployee (@EmployeeName char(8)) as
exec('select ''' + @EmployeeName + '''' + ' from 员工表 order by ''' + @EmployeeName + '''')

[pengdali]

CREATE PROCEDURE FindInEmployee (@EmployeeName char(8)) as
exec('select '+@EmployeeName+' from 员工表 order by '+@EmployeeName)