可用。存储分页

USE [Studentnew]
GO
/****** Object:  StoredProcedure [dbo].[pageYe]    Script Date: 05/04/2012 16:37:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER procedure [dbo].[pageYe]
@PageIndex int,--页面索引计数，计数0为第一页。
@PageSize int,--每个页面显示大小
@RecordCount int output,
@PageCount int output --页数
as
/*获取记录数*/
Select @RecordCount = COUNT(*) FROM a
/*计算页面数据*/
SET @PageCount = CEILING(@RecordCount * 1.0 / @PageSize)
---
Select SerialNumber,id,Name FROM
(Select id,Name,ROW_NUMBER() OVER (ORDER BY id DESC) AS SerialNumber
FROM a) AS T
Where T.SerialNumber > (@PageIndex * @PageSize)  
and T.SerialNumber <= ((@PageIndex+1) * @PageSize)
/*****
declare @RecordCount int, @PageCount int
exec pageYe 0,3,@RecordCount output,@PageCount output
print '总记录数'+ cast(@RecordCount as varchar(100))--拼接字符串要把整型转换为字符串

print '总页数'+convert(varchar(100),@PageCount)
*****/