/* 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...
阅读:317
评论:0