用sql语句快速备份表数据

1.Sql Server 数据库

--DataTable 原数据表--DataTable_20150717 要备份的新表名select * into DataTable_20150717 from DataTable Where [条件1,条件2];

2.Oracle 数据库

--创建表结构create table Table_20150720 as select * from Table where 1=2;--备份指定数据 insert into Table_20150720select * from Table Where [条件1,条件2]