摘要：
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... 阅读全文