sql实现分页

  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