摘要: 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 ) .. 阅读全文
posted @ 2012-03-27 22:20 Soar、毅 阅读(435) 评论(1) 推荐(0) 编辑