存储过程分页问题
alter procedure selectProducts@prt_name varchar(50),
@pagesize int,
@currentpage int
as
begin
select top @pagesize a.imgesid,a.productsname,a.id,a.jiage,a.xinghao,a.guige,a.chandi,b.dizhi,b.lianxinum,b.dianziemail,b.youbian,a.partername,b.parternames
from Products a,jianli b where a.partername = b.partername and a.shenhe = 0 and productsname like @prt_name and a.id not in (select top @pagesize*(@currentpage-1) a.id
from Products a,jianli b where a.partername = b.partername and a.shenhe = 0 like @prt_name order by a.id)order by a.id
end
