SQL Server中,如果目标表不存在:
select
*
into
目标表
from
原表;
例: select * into t_Inventory_20200619 from t_Inventory;
SQL Server中,如果目标表存在:
insert
into
目标表
select
*
from
原表;
例:insert
into
t_Inventory select
*
from
t_Inventory_20200619;
Oracle中,如果目标表存在:
insert
into
目标表
select
*
from
原表;
commit
;
Oracle中,如果目标表不存在:
create
table
目标表
as
select
*
from
原表;
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]