sql实现分页

weixin_30839881

于 2016-02-15 12:27:00 发布

阅读量46

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/miaoying/p/5190279.html

  IF EXISTS(SELECT * FROM sysobjects WHERE name='usp_getPage')
  DROP PROC usp_getPage
  GO
  CREATE PROC usp_getPage
  @totalCount INT OUTPUT,
   @PageIndex int=1,
   @PageCount INT=5
  AS
  SELECT * FROM (SELECT ROW_NUMBER() OVER(ORDER BY classid) AS id,* FROM dbo.Class) AS temp WHERE id BETWEEN
   @PageCount*(@PageIndex-1)+1 AND @PageCount*@PageIndex
   SET @totalCount=CEILING((SELECT COUNT(*) FROM dbo.Class)*1.0/@PageCount)
  GO
 
 DECLARE @count INT 
 exec usp_getPage @count OUTPUT,2,2
 PRINT @count