DECLARE @keys nvarchar(200) DECLARE @pageindex int DECLARE @pagesize int DECLARE @classid int set @keys = '' set @pageindex = 1; set @pagesize = 20; set @classid = 17; with temptbl as ( select ROW_NUMBER() OVER (ORDER BY B.iid desc)AS Row, A.className,B.* from dl_PicClass A inner join dl_PicFile B on a.iid = b.classid where (@keys = '' or A.className like '%'+@keys+'%' or B.fName like '%'+@keys+'%' ) and (@classid<=0 or B.classid = @classid) ) SELECT * FROM temptbl where Row between (@pageindex-1)*@pagesize+1 and (@pageindex-1)*@pagesize+@pagesize; select COUNT(1) from dl_PicClass A inner join dl_PicFile B on a.iid = b.classid where (@keys = '' or A.className like '%'+@keys+'%' or B.fName like '%'+@keys+'%' ) and (@classid<=0 or B.classid = @classid)
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步