2009年6月16日
非常NB的sql2005分页
摘要： declare @PageIndex as intdeclare @PageSize as intset @PageIndex = 4648set @PageSize = 20SELECT *FROM (SELECT ROW_NUMBER() OVER (ORDER BY pro_id DESC)AS Row, * FROM products_data) as listWHERE Row betw... 阅读全文
posted @ 2009-06-16 16:47 小师傅 阅读(152) 评论(0) 推荐(0) 编辑