SQLServer 通用分页存储过程(使用游标)

SQL代码

/*
Powered By CMSDream Copyright (c) All rights reserved.
通用分页存储过程
*/
CREATE proc [dbo].[cmsdream_SP_MultiPage](
@sql varchar(8000)='',
@PageSize int=1,
@CurrentPage int=1,
@RecordCount int=0 output,
@PageCount int=1 output
)AS
if @PageSize < 1 set @PageSize = 1
if @CurrentPage < 1 set @CurrentPage = 1
begin
set nocount on
declare @p1 int,
@rowcount int
exec...

阅读：345 评论：0