存储过程笔记

CREATE PROC t
(
    @pageIndex INT ,
    @pageSize INT ,
    @pageSum INT output
)
AS
DECLARE @DataCounts INT 
 
SET @DataCounts=(SELECT COUNT(*) FROM sysmenu)
SET @pageSum=(@DataCounts*1.0 / @pageSize)
SELECT * FROM (
SELECT *,num= ROW_NUMBER() OVER (ORDER BY Id )FROM sysmenu
)AS t
WHERE t.num BETWEEN  @pageSize*(@pageIndex-1) AND @pageSize*@pageIndex


GO

EXEC t 1,10,10
EXEC t 2,10,10
EXEC t 3,10,10