SQL 分页

sql = "SELECT TOP 10000 * " +
" FROM(SELECT ROW_NUMBER() OVER(ORDER BY DataArticleID) AS RowNumber, *FROM( ";

。。。。。。

sql += ")table1 ) as A " +
" WHERE RowNumber > 0 ";

原文地址:https://www.cnblogs.com/riusmary/p/5983643.html