sql分页查询

@"SELECT * 

   　FROM( SELECT ROW_NUMBER()OVER(ORDER BY ID ASC) AS RowNumber,*

               FROM GoodSpec  ) AS TEMPTABLE

      WHERE RowNumber >@pageSize*(@curentPage-1) AND RowNumber<@pageSize*@curentpage;";

本人多次用到 希望能够有用

转载于:https://my.oschina.net/u/1158740/blog/306602