1.Sql Server 数据库
    [sql] view plain copy

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

    2.Oracle 数据库
    [sql] view plain copy

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