帮忙
- SQL code
str = "select *,ROW_NUMBER() over(order by TimeST) ROWID from"+TName3[i]; str += "select * from " + TName3[i] + " where ROWID between 0 and 200";
转换成SQL 2000代码
[解决办法]
- SQL code
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";