str = "select *,ROW_NUMBER() over(order by TimeST) ROWID from"+TName3[i];
                    str += "select * from " + TName3[i] + " where ROWID between 0 and 200";

str = "select *, ROWID=identity(int,1,1) into # from"+TName3[i]+"order by order by TimeST;"
                    str += " select * from # where ROWID between 0 and 200";

------解决方案--------------------
多打了个 order by
SQL code
str = "select *, ROWID=identity(int,1,1) into # from"+TName3[i]+" order by TimeST;"
                    str += " select * from # where ROWID between 0 and 200";