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

sqlserver 多条件+分页查询

相关推荐