SQL Server 2008 分页与驱动

SQL Server 2008 分页与驱动

分页部分：
BETWEEN 开始 and 显示内容

关联分页语句
SELECT FROM (SELECT a.,b.names,ROW_NUMBER() OVER (ORDER BY a.id ASC ) AS rowNum FROM fp_admin_user a LEFT JOIN fp_admin_group b ON b.agid=a.gid WHERE a.id=1 OR a.host_id=0
) b WHERE b.rowNum BETWEEN 1 and 5

单查询分页
SELECT FROM (SELECT ,ROW_NUMBER() OVER (ORDER BY cate_id ASC) AS FPNum FROM fp_category WHERE types=’articles_keyword’
) FoundPHP WHERE FoundPHP.FPNum BETWEEN 1 and 5