时间: 2021-08-13 作者:daque
* 数据库分页保存进程---equn.net 参数证明: ?tablename为探求表名 ?where为探求表名,要表露一切记载请设为"1=1" ?orderby为探求截止排序,如order by id desc ?curpage暂时页码 ?page_record每页记载条数 截止: ?归来表tablename中满意前提where的第curpage页的page_record条记载,截止按orderby排序 */ create procedure xp_page(@tablename varchar(50),@where varchar(100),@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 ’+@tablename+’ where ’+@where+’ and id not in (select top ’+cast(@uprecord as char)+’ id from ’+@tablename+’ where ’+@where+’ ’+@orderby +’) ’+@orderby ?exec(@cmd) end go