1、备份表
sqlserver : select * into 表名 from table;
oracle : insert into t select * from table;
craete table t as select * from table;
2、更新多列
sqlserver :
UPDATE T SET B=b_bak,c=c_bak from t as e, (SELECT a,B as b_bak,c as c_bak FROM TT) f where e.a=f.a;
oracle :
update t set (b,c) = (select b,c from tt where tt.a = t.a)