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

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

• sql
• 存储过程
• 技术人生
• 数据库语言
• 游标