整理后的分页存储过程

白鼠闹东京

于 2013-04-10 13:29:43 发布

阅读量623

点赞数

分类专栏： mssql

本文链接：https://blog.youkuaiyun.com/sbt0198/article/details/8782408

版权

mssql 专栏收录该内容

13 篇文章

订阅专栏

CREATE PROCEDURE [dbo].[Pr_appLog]
	@pageindex int = 1,
	@pagesize int =10
AS
BEGIN
	--首先要先给查询出来的表增加行号
	SELECT * FROM (SELECT *,(ROW_NUMBER() over(ORDER by ID desc)) as Pcount FROM app_logs) as B
		WHERE B.Pcount BETWEEN (@pageindex-1)*@pagesize+1 AND @pageindex*@pagesize
END