存储过程中用临时表实现分页

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28

CREATE PROCEDURE [dbo].[V2_WEB_A_Gis_GetList]     @FatherId INT,     @PageIndex INT,     @PageSize INT,     @Num INT OUTPUT AS BEGIN     DECLARE @MinId INT     DECLARE @MaxId INT     SET @MinId = (@PageIndex - 1) * @PageSize     SET @MaxId = @MinId + @PageSize     CREATE TABLE #TempTable     (         IndexId INT IDENTITY(1,1) NOT NULL,         Id INT     )     INSERT INTO #TempTable(ID)         SELECT Id             FROM Area             WHERE FatherId = @FatherId             ORDER BY Id DESC     SET @Num = (SELECT count(0) From #TempTable)     SELECT A.*         FROM Area A INNER JOIN #TempTable B ON A.Id = B.Id         WHERE B.IndexId > @MinId AND B.IndexID <=@MaxId         ORDER BY B.IndexId     DROP TABLE #TempTable END