ALTER PROC SP_PER_PAGE_DATA
--CREATE PROC SP_PER_PAGE_DATA
@PAGES INT,--第几页数
@PREC INT, --每页记录数
@TOTALP NUMERIC(18) OUTPUT
AS
SELECT FirstName,LastName,Country,Note,IDENTITY(INT,1,1) ID INTO #TEMP FROM TestTABLE
SELECT * FROM #TEMP WHERE ID>=(@PAGES-1)*@PREC+1 AND ID<=@PREC*@PAGES
SELECT @TOTALP=CEILING(COUNT(*)/CAST(@PREC AS NUMERIC(18,1))) FROM #TEMP
DROP TABLE #TEMP
--测试
DECLARE @SS NUMERIC(18)
EXEC SP_PER_PAGE_DATA 1,200,@SS OUTPUT
SELECT @SS