通用存储过程分页(top max模式)（General storage procedure paging (top max)）.doc

通用存储过程分页(top max模式)（General storage procedure paging (top max)） --/* storage procedure paging processing Sun Wei 2005-03-28 created */ --/* were 2 points for data processing to query first half performance data of the same data and query the second half of */ --/* storage procedure paging processing Sun Wei 2005-04-21 modified to add the Distinct query function */ --/* storage procedure paging processing Sun Wei 2005-05-18 modified multi field collation problems */ --/* storage procedure paging processing Sun Wei 2005-06-15 modified multi sort field modification */ --/* storage procedure paging processing Sun Wei 2005-12-13 modify data paging mode for top Max mode performance has greatly improved */ --/* disadvantages: not in version before the relative key is only integer fields, such as the primary key for type GUID use the not in model */ version CREATE PROCEDURE c_ListPageInt ( @tblName nvarchar (200), -- to show the table or tables connection @fldName nvarchar (500) = *, to display a list of fields. @pageSize int = 10, - page shows the number of records @page int = 1, - to display the page of records @pageCount int = output - 1, the total number of pages of the search results page @Counts int = 1 output - query to the number of records @fldSort nvarchar (200) = null - sort field list or condition @Sort bit = 0, 0 - ranking method for ascending, descending to 1 (if it is a multi field arrangement of Sort refers to the last sort field sequence (the last sort field without sorting marker) -- program parameters such as: SortA Asc, SortB Desc, SortC) @strCondition nvarchar (1000) = null, - query, without where @ID, nvarchar (150) - the main table @Dist bit = 0, whether to add query field DISTINCT add /1 add default 0 ) AS SET NOCOUNT ON Declare @sqlTmp nvarchar (1000) - store dynamically generated SQL statement Declare @strTmp nvarchar (1000) - storage total query query results achieved Declare @strID nvarchar (1000) - stored queries made the beginning or ending of