[导入]Sql Server2005简单分页
SELECT RowNum, PrivilegeName
FROM
(SELECT PrivilegeName,
ROW_NUMBER() OVER (ORDER BY PrivilegeId) as RowNum
FROM wmf_Privilege
) as s where RowNum Between 10 and 20
类别：Sql Server 查看评论
文章来源:http://hi.baidu.com/woxxf/blog/item/8a6e614edbdfc0cdd0c86a48.html
FROM
(SELECT PrivilegeName,
ROW_NUMBER() OVER (ORDER BY PrivilegeId) as RowNum
FROM wmf_Privilege
) as s where RowNum Between 10 and 20
类别：Sql Server 查看评论
文章来源:http://hi.baidu.com/woxxf/blog/item/8a6e614edbdfc0cdd0c86a48.html
