摘要： 下面选用的是新闻发布系统里用的代码。SQL 存储过程：CREATE PROCEDURE procNewsSelectByPager @startRecordIndex int, @endRecordIndex intASBEGIN select * from (select row_number() over (order by id) as row, * from news) temp where temp.row between @startRecordIndex and @endRecordIndexENDGO数据访问层：//SQLHelperpublic ... 阅读全文