set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
-- =============================================
-- Author: jiangbo
-- Create date: 2014-07-09 13:32:20
-- Description: 分页存储过程
-- =============================================
ALTER PROCEDURE [dbo].[GetPages]
@PageIndex int,
@PageSize int,
@RecordCount int out,/*总记录数*/
@PageCount int out/*总页数*/
AS
BEGIN
/*获取数据的总记录数*/
select @RecordCount=count(*) from UserInfo
/*计算总数据可以分成几个页面*/
set @PageCount = ceiling(@RecordCount*0.1/@PageSize)/*ceiling函数返回大于或等于所给数字表达式的最小整数。*/
select SerialNumber,Id,Name,Age,Sex,Email,Address,Phone from
(select Id,Name,Age,Sex,Email,Address,Phone,ROW_NUMBER() over(order by Id desc) as SerialNumber from UserInfo) as T
where T.SerialNumber >(@PageIndex*@PageSize) and T.SerialNumber <=((@PageIndex+1)* @PageSize)
END
select * from UserInfo