/************************ PageByTopMax************************/
IF EXISTS ( SELECT * FROM sys.objects WHERE object_id = OBJECT_ID ( N'[dbo].[PageByTopMax]' ) AND type in ( N'P' , N'PC' ))
DROP PROCEDURE [dbo]. [PageByTopMax]
go
CREATE PROCEDURE [dbo]. [PageByTopMax]
@tableName varchar ( 255),
@fieldName varchar ( 1000) = '*' ,
@PageSize int = 10, -- 页尺寸 ( 每页记录数 )
@page int = 1, -- 页码
@fieldSort varchar ( 255)= '' , -- 排序的字段名
@sort bit = 0, -- 配......
阅读全文