預存程序中用暫存資料表實現分頁

CREATE PROCEDURE [dbo].[V2_WEB_A_Gis_GetList]@FatherId INT,@PageIndex INT,@PageSize INT,@Num INT OUTPUTASBEGINDECLARE @MinId INTDECLARE @MaxId INTSET @MinId = (@PageIndex - 1) * @PageSizeSET @MaxId = @MinId + @PageSizeCREATE TABLE #TempTable(IndexId INT IDENTITY(1,1) NOT NULL,Id INT)INSERT INTO #TempTable(ID)SELECT IdFROM AreaWHERE FatherId = @FatherIdORDER BY Id DESCSET @Num = (SELECT count(0) From #TempTable)SELECT A.* FROM Area A INNER JOIN #TempTable B ON A.Id = B.IdWHERE B.IndexId > @MinId AND B.IndexID <=@MaxIdORDER BY B.IndexIdDROP TABLE #TempTableEND