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

。。。。。。

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

SQL 分页