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 查询的数据行数