2008年4月30日
SQL2005分页查询语句！
摘要： with temptbl as (SELECT ROW_NUMBER() OVER (order by ProductID)AS Row, * from Products)SELECT * FROM temptbl where Row between (@pageindex)*@pagesize+1 and (@pageindex)*@pagesize+@pagesize每次只读取17条数据出来，... 阅读全文
posted @ 2008-04-30 15:12 ansonpan 阅读(1461) 评论(0) 推荐(0) 编辑