帮我把这条SQL语句改成在SQL里可用的存储过程

alter procedure dbo.pager @OrderBy varchar(64) ,@orderType varchar (64) ,@Field varchar(64),@where varchar(256) as begin declare @lssql nvarchar(1024) set @lssql='select * from (select row_number() over(order by '+@OrderBy+' '+@Order