返回首頁
當前位置: 主頁 > 網絡編程 > .Net實例教程 >

SQL導出的備份文件語句

時間:2010-11-02 00:32來源:知行網www.f1globe.com 編輯:麥田守望者

prompt PL/SQL Developer import file
prompt Created on 2009年2月10日 by netgy
set feedback off
set define off
prompt Disabling triggers for LY_CC...
alter table LY_CC disable all triggers;
prompt Deleting LY_CC...
delete from LY_CC;
commit;
prompt Loading LY_CC...
insert into LY_CC (AGENT_ID, OWNER, USER_NAME, TELEPHONE, MOBILE, ADDRESS, PROVINCE, CITY, CITY2, POST_CODE, EMAIL, CONTENT, IP, LY_DATE, CREATE_DATE, STATUS, STATUS_DATE, VAR1, VAR2, NUM1, DATE1, ZILIAO_ID, RELEASE_DATE, PROJECT_CODE, PROJECT_NAME, COMPANY_CODE, COMPANY_NAME, SUB_PROJECT, VAR3, VAR4, NUM2, NUM3, STATUS_DESC, REASON, CC_TIME, CREATE_LY_CC_TIME, OPERATOR)
values (46, 'fu001', 'sss0', null, '13699141506', '北京北京市s', null, '北京市', ' self', '13245', 'sss0@126.com', 'tes', '126.10.0.1', to_date('25-12-2008', 'dd-mm-yyyy'), to_date('25-12-2008 14:24:43', 'dd-mm-yyyy hh24:mi:ss'), 70, to_date('25-12-2008 14:24:43', 'dd-mm-yyyy hh24:mi:ss'), null, '1', 324, to_date('25-12-2008 14:24:43', 'dd-mm-yyyy hh24:mi:ss'), 45, to_date('25-09-2008', 'dd-mm-yyyy'), '123654', 'sss', '4578', 'ss', null, null, null, 2, 0, null, null, null, to_date('29-12-2008 15:16:43', 'dd-mm-yyyy hh24:mi:ss'), null);
insert into LY_CC (AGENT_ID, OWNER, USER_NAME, TELEPHONE, MOBILE, ADDRESS, PROVINCE, CITY, CITY2, POST_CODE, EMAIL, CONTENT, IP, LY_DATE, CREATE_DATE, STATUS, STATUS_DATE, VAR1, VAR2, NUM1, DATE1, ZILIAO_ID, RELEASE_DATE, PROJECT_CODE, PROJECT_NAME, COMPANY_CODE, COMPANY_NAME, SUB_PROJECT, VAR3, VAR4, NUM2, NUM3, STATUS_DESC, REASON, CC_TIME, CREATE_LY_CC_TIME, OPERATOR)
values (46, 'fu001', 'sss0', null, '13699141506', '北京北京市s', null, '北京市', ' self', '369', 'sss0@126.com', 'tes', '126.10.0.1', to_date('25-12-2008', 'dd-mm-yyyy'), to_date('25-12-2008 14:24:43', 'dd-mm-yyyy hh24:mi:ss'), 70, to_date('25-12-2008 14:24:43', 'dd-mm-yyyy hh24:mi:ss'), null, '1', 322, to_date('25-12-2008 14:24:43', 'dd-mm-yyyy hh24:mi:ss'), 45, to_date('25-09-2008', 'dd-mm-yyyy'), '123654', 'netgy', '7455', '共贏', null, null, null, 1, 0, null, null, null, to_date('26-12-2008 15:15:48', 'dd-mm-yyyy hh24:mi:ss'), null);
commit;
prompt 2 records loaded
prompt Enabling triggers for LY_CC...
alter table LY_CC enable all triggers;
set feedback on
set define on
prompt Done.

------分隔線----------------------------
標簽(Tag):SQLServer2005 數據庫
------分隔線----------------------------
推薦內容
猜你感興趣
99久久免费高清热精品