2012年8月7日
SQL 分页
摘要： WITH MOVIES AS ( SELECT ROW_NUMBER() OVER (ORDER BY uid desc)AS Row,* FROM ValorUser WHERE UserType=1 ) SELECT * FROM MOVIES WHERE Row between (@PageIndex-1)* @PageSize+1 and @PageIndex*@PageSize ORDER BY [uid] DESCWITH MOVIES AS ( SELECT ROW_NUMBER() OVER (ORDER BY uid desc)AS Row,* FR... 阅读全文
posted @ 2012-08-07 11:30 划破黑夜 阅读(149) 评论(0) 推荐(0)