SQLserver row_number分页、where 条件判断

SELECT * FROM(
SELECT row_number() over(order by de.new_actsubfile_idname) as PM) as t
WHERE t.PM between (2-1)2+1 and 22 --《pageIndex=当前页、pageSize=分页数》between (pageIndex-1)pageSize+1 and pageIndexpageSize

--SQLserver查询加分页
SELECT * FROM(
SELECT DISTINCT row_number() over(order by de.new_actsubfile_idname) as PM,de.new_actsubfile_idname as '客户简称',de.new_designinname as 'Design In人员',de.new_businessunitname as '原事业部',de.new_systemuser_idname as '原业务员',de.new_salesmanagername as '原销售经理',de.new_budirectorname as '原事业部总监',mg.new_businessunitname as '新事业部',mg.new_systemuser_id2name as '新业务员',mg.new_salesmanagername as '新销售经理',mg.new_budirectorname as '新事业部总监',de.new_oldcommissiontype_idname as '原佣金类别',de.new_commissiontype_idname as '新佣金类别',convert(char(10) ,mg.new_approvaldate , 120) as '变更日期',convert(char(10),de.new_kpienddate,120) as '业绩核算结束日期' FROM new_salechange_mg mg 
LEFT JOIN new_salechange_detail de on de.new_salechange_mg_id = mg.new_salechange_mgid ) as t 
WHERE t.PM between (2-1)*2+1 and 2*2 --《pageIndex=当前页、pageSize=分页数》between (pageIndex-1)*pageSize+1 and pageIndex*pageSize

sqlserver where 条件判断

where
(1 = (CASE WHEN @a IS NULL THEN 1 ELSE 0 END)
OR  a=@a )
AND b=@b