分页存储过程

最新推荐文章于 2025-08-30 19:53:37 发布

weixin_30314813

最新推荐文章于 2025-08-30 19:53:37 发布

阅读量48

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/VirtualLive/archive/2010/09/17/1828989.html

USE [TCM_Channels]
GO
/****** Object: Test_Kind[dbo].[pro_Test_Kind_Select_Page] Script Date: 07/20/2010 09:24:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <齐XX>
-- Create date: <2010-07-20>
-- Description: <查询数据内容并分页>
-- 参数 @result 查询条件，@pagesize 一页多少条记录，@currentpage 当请页数
-- 调用 exec pro_Test_Kind_Select_Page '','3','1'
-- =============================================

create PROC pro_Test_Kind_Select_Page
@result varchar(50),
@pagesize varchar(4),
@currentpage varchar(4)
as

BEGIN
declare @condition varchar(2000)
set @condition=' '

if(len(@result)>0 )
begin
set @condition += @result
end

declare @sql varchar(4000)
set @sql = 'select * from (select * ,ROW_NUMBER() over(order by KId) as RowNum from dbo.Test_Kind where 1=1 '+ @condition +') as z where RowNum > ('+ @pagesize +'*('+ @currentpage +'-1)) and RowNum<=('+ @pagesize +'*'+ @currentpage +')'
exec (@sql)

END

------------------------------------------------------------------------------------------------------------------------------------

转载于:https://www.cnblogs.com/VirtualLive/archive/2010/09/17/1828989.html