可用。存储分页

来源：互联网发布：ui框架和js框架编辑：程序博客网时间：2024/05/29 06:48

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)
*****/