用sql语句快速备份表数据

1.Sql Server 数据库
select * into DataTable_20150717   from DataTable Where [条件1,条件2]; 


2.Oracle 数据库
create table DataTable_20170407 as select * from Table where 1=2; 
insert into DataTable_20170407 select * from Table Where [条件1,条件2]