摘要:
CREATE PROCEDURE [dbo].[V2_WEB_A_Gis_GetList] @FatherId INT, @PageIndex INT, @PageSize INT, @Num INT OUTPUTASBEGIN 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 ) .. 阅读全文