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...
16年前9月20日
阅读:345
评论: