展开全部
USE [2881]
GO
/****** Object: StoredProcedure [dbo].[sp_rowpages] Script Date: 06/12/2017 09:55:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Description: <>
-- Status: <>
-- =============================================
ALTER PROCEDURE [dbo].[sp_rowpages]
@TableName NVARCHAR(1024), /* 数据表名 */
@SQLFields NVARCHAR(1024) = NULL, /* 显示字段(支持多字段,以逗号分隔636f70793231313335323631343130323136353331333365666264) */
@SQLWhere NVARCHAR(1024) = NULL, /* 查询条件 */
@OrderFields NVARCHAR(255) = NULL, /* 显示排序字段(支持排序字,多字段以逗号分隔) */
@PageSize INT = 10, /* 每页的大小(记录数) */
@PageIndex INT