SQL分页方法
--适用于SQL2005的新性能
SELECT top 50 * FROM
(
SELECT ROW_NUMBER() OVER (ORDER BY ID) AS RowNo,*
FROM product
) AS A
WHERE RowNo >50*254
--适用于SQL2000
select top 50 * from product where ID not in (select top (50*253) id from product order by id) order by id