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