比较smart的一条分页存储过程
别人的发明,看起来很不错,比较有想法:
select * from tblExternalProduct where ProductId in
(
Select top 10 ProductId From
(Select top 20 ProductId From tblExternalProduct order by productId desc) as ep order by ep.productid asc
)
order by productid desc