mssql存储过程分页

USE [testdb]
GO
/****** Object: StoredProcedure [dbo].[proc_paged_with_Rownumber] Script Date: 03/29/2021 17:22:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[proc_paged_with_Rownumber]
(
@pageIndex INT,
@pageSize INT
)
AS
DECLARE @timediff DATETIME
BEGIN
SET NOCOUNT ON;
SELECT @timediff = GETDATE()
select * from (select *,Row_number() over(order by ID asc) as IDRank from dbo.Student) as IDWithRowNumber where IDRank>@pageSize*@pageIndex and IDRank<=@pageSize*(@pageIndex+1)
SELECT DATEDIFF(ms,@timediff,GETDATE()) AS 耗时
SET NOCOUNT OFF;
END