日期:2014-05-16 浏览次数:20862 次
SQL codeselect * from (select *,row_number() over(ORDER BY trandate) as num from #t) aa where num between (@CurrPage-1)*@PageSize+1 and @CurrPage*@PageSize