Sqlserver 分页存储过程

工作中遇到的问题：自己定义查询参数的存储过程如何加入分页

USE [RMIS]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER PROCEDURE [dbo].[usp_GetTestList]
	@Test nvarchar (20),
	@pageSize int,
	@PageIndex int
	
AS
BEGIN

select * from (
	select *,row_number() over(order by RepairDate asc) as rownum,count(*) over() AS RecordCount  					 
		from (
				select * from TestView where Test like '%'+@Test +'%'
			) as a
				) seq 
where seq.rownum between (@pageSize*(@PageIndex-1))&#