【转】分页存储过程

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