T-SQL语句: //把T从第m+1行到第n行复制给t1,我没试过,你试试看行不行。n>m,编号要是主键或唯一 select * into t1 from (select Top n * from T where T.编号<>all(select top m 编号 from T ))
你的编号是主键吧?假定它的列名是id, 数量列名是num String sql = "select id, num from t1 where num > 1"; ... ResultSet rs = db.executeQuery(sql); while(rs.next()){ for(int i = 0; i < rs.getInt("num"); i++){ db.executeUpdate("insert into t1(id, num) values(" + rs.getString("id")+ i + ", 1)"; } db.executeUpdate("delete from t1 where id = " + rs.getString("id")); }
//把T从第m+1行到第n行复制给t1,我没试过,你试试看行不行。n>m,编号要是主键或唯一
select * into t1 from (select Top n * from T where T.编号<>all(select top m 编号 from T ))
String sql = "select id, num from t1 where num > 1";
...
ResultSet rs = db.executeQuery(sql);
while(rs.next()){
for(int i = 0; i < rs.getInt("num"); i++){
db.executeUpdate("insert into t1(id, num) values(" + rs.getString("id")+ i + ", 1)";
}
db.executeUpdate("delete from t1 where id = " + rs.getString("id"));
}