ALTER PROCEDURE [dbo].[Sp_Paging_RowNumber]
--exec Sp_Paging_RowNumber 10,50
@pagenum int =1,
@pagesize int=1
AS
BEGIN
SET NOCOUNT ON;
SELECT *
FROM (SELECT ROW_NUMBER() OVER(ORDER BY id DESC) AS rownum, id, [name] ,[password]
FROM test1) AS D
WHERE rownum BETWEEN (@pagenum-1)*@pagesize+1 AND @pagenum*@pagesize
END