sqlserver 分页

核心还是写sql 只不过sqlserver分页使用的是ROW_NUMBER 具体的实现请看下面的sql：

SELECT * FROM (        SELECT *,ROW_NUMBER() Over(order by applyId        desc,appDate desc) AS rowNum        FROM AGENT_APPLY        <dynamic prepend="WHERE">            <isNotNull prepend="AND" property="applyID"> applyID=#applyID#</isNotNull>            <isNotNull prepend="AND" property="taobaoID">taobaoID like                '%$taobaoID$%'</isNotNull>            <isNotNull prepend="AND" property="appStatus">appStatus=#appStatus#</isNotNull>        </dynamic>        order by applyId desc,appDate desc        )AS myTable WHERE rowNum between        #rowNumStart# and #rowNumEnd#解释：rowNumStart起始页rowNumEnd 查询的数据行数