declare @sizePage int=3
declare @currentPage int=2
select top 3 * from ( select ROW_NUMBER() over(order by ID asc) as RowNumber ,*from Product) as temp
where RowNumber>(@currentPage-1)*@sizePage
sql分页
原文：http://www.cnblogs.com/scc211/p/5524933.html
