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