51CTO博客开发
CREATE OR REPLACE PROCEDURE PAGING (TableName IN VARCHAR,Fields IN VARCHAR DEFAULT '*',OrderField IN VARCHAR,sqlWhere VARCHAR,pageSize IN INT,pageIndex IN INT DEFAULT 1,totalPage O
CREATE PROCEDURE PageDiv( IN tableName varchar(100), IN filedsNames varchar(500), IN pageSize int, IN pageIndex int, IN strWhere varchar(500), IN sortName varchar(500) ) BE
--调用方法：exec upPageDiv kucun,'id,ItemCode,ItemName','ItemCode asc','id>0',20,1,?,? Create Procedure [dbo].[upPageDiv] @TableName varchar(200),
Copyright © 2005-2025 51CTO.COM 版权所有 京ICP证060544号
