摘要: @"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;";本人多次用到 希望能够有用 阅读全文
posted @ 2012-06-13 16:35 开心学习吧 阅读(130) 评论(0) 推荐(0)