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