分页查询
摘要:
SQL2005:@pageIndex为当前页码,每页10条记录。 SELECT TOP 10 * FROM ( SELECT *,ROW_NUMBER() OVER (ORDER BY NewsID) AS RowNo FROM T_News ) AS A WHERE RowNo > (@pageIndex-1)*10 SQL2... 阅读全文
posted @ 2006-06-06 18:19 蒜头 阅读(297) 评论(0) 推荐(0) 编辑