sql = "SELECT TOP 10000 * " +
" FROM(SELECT ROW_NUMBER() OVER(ORDER BY DataArticleID) AS RowNumber, *FROM( ";
。。。。。。
sql += ")table1 ) as A " +
" WHERE RowNumber > 0 ";
原文：http://www.cnblogs.com/riusmary/p/5983643.html