@"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;";
本人多次用到 希望能够有用
@"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/306614