更新表、备份表、 sqlserver + oracle
[code="java"]
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_b...
原创
2013-12-05 08:55:24 ·
110 阅读 ·
0 评论