参数说明:
tablename为搜索表名
tablefield为表的字段,约定为表的主键,
where为搜索表名,要显示所有记录请设为"1=1"
orderby为搜索结果排序,如order by id desc
curpage当前页码
page_record每页记录条数
结果:
返回表tablename中满足条件where的第curpage页的page_record条记录,结果按orderby排序
*/
CREATE PROCEDURE OGuess_CommonPaging
@tablename varchar(50),
@tablefield varchar(20),
@where varchar(500),
@orderby varchar(100),
@curpage int,
@page_record int
AS
BEGIN
DECLARE @cmd varchar(500)
DECLARE @uprecord int
SET @uprecord=@curpage * @page_record
SET @cmd='SELECT TOP '+cast(@page_record as char)+' * FROM WHERE and not in (SELECT TOP '+cast(@uprecord as char)+' FROM WHERE +')
EXEC(@cmd)
END
GO
阅读(377) | 评论(0) | 转发(0) |