sqlserver 多条件+分页查询

declare @curPage int,@pageSize int,@startNum int,@endNum int，@title nvarchar(50),@htlb nvarchar(50)
set @startNum=(@curPage-1)*@pageSize+1
        set @endNum=@curPage*@pageSize
        select * from (select row_number()over(order by id)rownumber,id,title,htlb 
        from uic_tms..ht_zt where (1=2 or @title='' or title like '%['+@title+']%') 
        and (1=2 or @htlb='' or htlb=@htlb))a where rownumber between @startNum and @endNum

 @curPage 为前页的页码,@pageSize为每一页显示的记录数,;  多条件查询，查询的条件可以又很多个，我这里 就只列举两个 分别为 @titile  和 @htlb

转载于:https://www.cnblogs.com/wsz168/p/8782293.html