摘要： SQL 分頁支持查詢 ROW_NUMBER() OVER (ORDER BY ReportID) AS RowNo 分頁支持查詢 SELECT * FROM (select *,ROW_NUMBER() Over(order by [id]) as row_index from [table] ) as [newtable] where row_index between [startindex] and [endindex] Sql Server 2000的自定義分頁,但是在sql server 2000中,要實現(xiàn)顯示某一頁,就返回那一頁數(shù)據(jù)的效果的方法實在不盡人意.網(wǎng)上很多通用的分頁存儲過 閱讀全文