sq沒啟動如何導出數據

Ⅰ 自選股可以導出和導入嗎

可以導出導入.先把界面點到自選股,在行情軟體 系統菜單---數據導出,選擇導出的目錄就可以了,我的導出的是TXT文件.

Ⅱ 生產企業出口退稅申報系統8.0版數據如何導出

有兩種方式：
1、菜單——》免抵退稅申報——》列印申報報表，填寫「列印帆橡沖所屬期」，然後在列印所屬期的右邊，選中「Excel列印」，再點擊「列印到EXCEL」，等EXCEL顯示完成之後，關閉該報表，然後到申報軟體安裝目錄下，找以「_」開頭的最新生成的XLS文件，明細表的就是態殲「_qqsq_sb_prt_tmp_dbf.xls」。
2、第二種方式，到「綜合數據查詢」中，查詢出你所需要的明細數據，點擊工具欄上的「列印」，選擇「報表如碼設置」，在「通用報表格式設定」對話框的最下邊，有一個「導出數據」按鈕，點擊就可以生成EXCEL報表了。

Ⅲ SQL SERVER中，如何把一個表中的數據導入到另一個表中

1、假如A表存在

則 insert into A(a,b,c) (select a,b,c from B)

2、假如A表雀唯不存在

select a,b,c into A from B

3、假如需要跨資料庫

insert into ADB.[dbo].A(a,b,c) (select a,b,c from BDB.[dbo].B)

(3)sq沒啟動如何導出數據擴展閱讀：

SQL導入語句

1、如果要導出數據到已經生成結構(即現存的)FOXPRO表中,可以直接用下面的SQL語句

insert into openrowset('MSDASQL',

'Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=c:',

'select * from [aa.DBF]')辯歲閉

select * from 表

說明：

SourceDB=c: 指定foxpro表所在的文件夾

aa.DBF 指定foxpro表的文件名.

2、導出到excel

EXEC master..xp_cmdshell 'bcp SettleDB.dbo.shanghu out c: emp1.xls -c -q -S"GNETDATA/GNETDATA" -U"sa" -P"攜裂"'

3、/** 導入文本文件

EXEC master..xp_cmdshell 'bcp dbname..tablename in c:DT.txt -c -Sservername -Usa -Ppassword'

Ⅳ Oracle如何導入導出expdp 數據

[plain] [oracle@localhost ~]$ expdp system/lubinsu Export: Release 10.2.0.1.0 - Proction on Wednesday, 01 May, 2013 17:04:18 Copyright (c) 2003, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Proction With the Partitioning, OLAP and Data Mining options Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/******** Estimate in progress using BLOCKS method... Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 320 KB Processing object type SCHEMA_EXPORT/USER Processing object type SCHEMA_EXPORT/SYSTEM_GRANT Processing object type SCHEMA_EXPORT/ROLE_GRANT Processing object type SCHEMA_EXPORT/DEFAULT_ROLE Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC Processing object type SCHEMA_EXPORT/DB_LINK Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE Processing object type SCHEMA_EXPORT/TABLE/TABLE Processing object type SCHEMA_EXPORT/TABLE/PRE_TABLE_ACTION Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT Processing object type SCHEMA_EXPORT/TABLE/GRANT/CROSS_SCHEMA/OBJECT_GRANT Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/漏梁CONSTRAINT Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS Processing object type SCHEMA_EXPORT/TABLE/則搜旁COMMENT Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE Processing object type SCHEMA_EXPORT/VIEW/VIEW Processing object type SCHEMA_EXPORT/VIEW/孫橡GRANT/OWNER_GRANT/OBJECT_GRANT Processing object type SCHEMA_EXPORT/VIEW/GRANT/CROSS_SCHEMA/OBJECT_GRANT Processing object type SCHEMA_EXPORT/VIEW/COMMENT Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT Processing object type SCHEMA_EXPORT/TABLE/TRIGGER Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Processing object type SCHEMA_EXPORT/TABLE/POST_TABLE_ACTION Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCACT_SCHEMA . . exported "SYSTEM"."REPCAT$_AUDIT_ATTRIBUTE" 5.953 KB 2 rows . . exported "SYSTEM"."REPCAT$_OBJECT_TYPES" 6.507 KB 28 rows . . exported "SYSTEM"."REPCAT$_RESOLUTION_METHOD" 5.648 KB 19 rows . . exported "SYSTEM"."REPCAT$_TEMPLATE_STATUS" 5.296 KB 3 rows . . exported "SYSTEM"."REPCAT$_TEMPLATE_TYPES" 5.914 KB 2 rows . . exported "SYSTEM"."DEF$_AQCALL" 0 KB 0 rows . . exported "SYSTEM"."DEF$_AQERROR" 0 KB 0 rows . . exported "SYSTEM"."DEF$_CALLDEST" 0 KB 0 rows . . exported "SYSTEM"."DEF$_DEFAULTDEST" 0 KB 0 rows . . exported "SYSTEM"."DEF$_DESTINATION" 0 KB 0 rows . . exported "SYSTEM"."DEF$_ERROR" 0 KB 0 rows . . exported "SYSTEM"."DEF$_LOB" 0 KB 0 rows . . exported "SYSTEM"."DEF$_ORIGIN" 0 KB 0 rows . . exported "SYSTEM"."DEF$_PROPAGATOR" 0 KB 0 rows . . exported "SYSTEM"."DEF$_PUSHED_TRANSACTIONS" 0 KB 0 rows . . exported "SYSTEM"."DEF$_TEMP$LOB" 0 KB 0 rows . . exported "SYSTEM"."LOGSTDBY$APPLY_MILESTONE" 0 KB 0 rows . . exported "SYSTEM"."LOGSTDBY$APPLY_PROGRESS":"P0" 0 KB 0 rows . . exported "SYSTEM"."LOGSTDBY$EVENTS" 0 KB 0 rows . . exported "SYSTEM"."LOGSTDBY$HISTORY" 0 KB 0 rows . . exported "SYSTEM"."LOGSTDBY$PARAMETERS" 0 KB 0 rows . . exported "SYSTEM"."LOGSTDBY$PLSQL" 0 KB 0 rows . . exported "SYSTEM"."LOGSTDBY$SCN" 0 KB 0 rows . . exported "SYSTEM"."LOGSTDBY$SKIP" 0 KB 0 rows . . exported "SYSTEM"."LOGSTDBY$SKIP_TRANSACTION" 0 KB 0 rows . . exported "SYSTEM"."MVIEW$_ADV_INDEX" 0 KB 0 rows . . exported "SYSTEM"."MVIEW$_ADV_PARTITION" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_AUDIT_COLUMN" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_COLUMN_GROUP" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_CONFLICT" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_DDL" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_EXCEPTIONS" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_EXTENSION" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_FLAVORS" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_FLAVOR_OBJECTS" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_GENERATED" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_GROUPED_COLUMN" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_INSTANTIATION_DDL" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_KEY_COLUMNS" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_OBJECT_ParmS" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_PARAMETER_COLUMN" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_PRIORITY" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_PRIORITY_GROUP" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_REFRESH_TEMPLATES" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_REPCAT" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_REPCATLOG" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_REPCOLUMN" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_REPGROUP_PRIVS" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_REPOBJECT" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_REPPROP" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_REPSCHEMA" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_RESOLUTION" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_RESOLUTION_STATISTICS" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_RESOL_STATS_CONTROL" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_RUNTIME_ParmS" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_SITES_NEW" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_SITE_OBJECTS" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_SNAPGROUP" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_TEMPLATE_OBJECTS" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_TEMPLATE_ParmS" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_TEMPLATE_REFGROUPS" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_TEMPLATE_SITES" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_TEMPLATE_TARGETS" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_USER_AUTHORIZATIONS" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_USER_Parm_VALUES" 0 KB 0 rows . . exported "SYSTEM"."SERV_MSG":"P_CZ" 0 KB 0 rows . . exported "SYSTEM"."SERV_MSG":"P_HA" 0 KB 0 rows . . exported "SYSTEM"."SERV_MSG":"P_LYG" 0 KB 0 rows . . exported "SYSTEM"."SERV_MSG":"P_NJ" 0 KB 0 rows . . exported "SYSTEM"."SERV_MSG":"P_NT" 0 KB 0 rows . . exported "SYSTEM"."SERV_MSG":"P_PROVICE" 0 KB 0 rows . . exported "SYSTEM"."SERV_MSG":"P_SQ" 0 KB 0 rows . . exported "SYSTEM"."SERV_MSG":"P_SZ" 0 KB 0 rows . . exported "SYSTEM"."SERV_MSG":"P_TZ" 0 KB 0 rows . . exported "SYSTEM"."SERV_MSG":"P_WX" 0 KB 0 rows . . exported "SYSTEM"."SERV_MSG":"P_XZ" 0 KB 0 rows . . exported "SYSTEM"."SERV_MSG":"P_YC" 0 KB 0 rows . . exported "SYSTEM"."SERV_MSG":"P_YZ" 0 KB 0 rows . . exported "SYSTEM"."SERV_MSG":"P_ZJ" 0 KB 0 rows . . exported "SYSTEM"."SQLPLUS_PRODUCT_PROFILE" 0 KB 0 rows Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded ****************************************************************************** Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is: /home/oracle/oracle/proct/10.2.0/db_1/rdbms/log/expdat.dmp Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at 17:04:57 其他用戶需要授權使用目錄對象： 1.創建目錄對象： [plain] [oracle@localhost ~]$ sqlplus system/lubinsu SQL*Plus: Release 10.2.0.1.0 - Proction on Wed May 1 17:07:28 2013 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Proction With the Partitioning, OLAP and Data Mining options SQL> create directory dpump_dir01 as '/home/lubinsu/dpump'; Directory created. 2.授權： [plain] SQL> grant read,write on directory dpump_dir01 to lubinsu; Grant succeeded. 3.導出： [plain] [lubinsu@localhost oracle]$ expdp lubinsu/lubinsu DIRECTORY=dpump_dir01 mpfile=lubinsu.dmp Export: Release 10.2.0.1.0 - Proction on Wednesday, 01 May, 2013 17:12:38 Copyright (c) 2003, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Proction With the Partitioning, OLAP and Data Mining options ORA-39002: invalid operation ORA-39070: Unable to open the log file. ORA-29283: invalid file operation ORA-06512: at "SYS.UTL_FILE", line 475 ORA-29283: invalid file operation 4.真實路徑下的目錄實際上並未創建，而oracle也不會自動創建該目錄 創建真是目錄並修改許可權： chmod 777 lubinsu chmod 777 dpump 將lubinsu用戶下的dpump開放給其他用戶 重新執行剛才的操作： [plain] [lubinsu@localhost oracle]$ expdp lubinsu/lubinsu mpfile=lubinsu.dmp directory=DPUMP_DIR05 Export: Release 10.2.0.1.0 - Proction on Wednesday, 01 May, 2013 22:24:43 Copyright (c) 2003, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Proction With the Partitioning, OLAP and Data Mining options Starting "LUBINSU"."SYS_EXPORT_SCHEMA_01": lubinsu/******** mpfile=lubinsu.dmp directory=DPUMP_DIR05 Estimate in progress using BLOCKS method... Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 128.6 MB Processing object type SCHEMA_EXPORT/USER Processing object type SCHEMA_EXPORT/SYSTEM_GRANT Processing object type SCHEMA_EXPORT/ROLE_GRANT Processing object type SCHEMA_EXPORT/DEFAULT_ROLE Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA Processing object type SCHEMA_EXPORT/DB_LINK Processing object type SCHEMA_EXPORT/TABLE/TABLE Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS Processing object type SCHEMA_EXPORT/TABLE/COMMENT Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS . . exported "LUBINSU"."T_TEST" 36.69 MB 393800 rows . . exported "LUBINSU"."GRID_MSG" 20.79 MB 156588 rows . . exported "LUBINSU"."BSS_PO_SPEC_D" 6.229 MB 26570 rows . . exported "LUBINSU"."MANAGER_TM" 3.885 MB 65099 rows . . exported "LUBINSU"."MANAGER_TM_T" 3.937 MB 65994 rows . . exported "LUBINSU"."AREA_TM" 1.786 MB 33105 rows . . exported "LUBINSU"."SERV_MSG":"P_CZ" 2.055 MB 10008 rows . . exported "LUBINSU"."SERV_MSG":"P_HA" 2.041 MB 10008 rows . . exported "LUBINSU"."SERV_MSG":"P_LYG" 1.991 MB 10008 rows . . exported "LUBINSU"."SERV_MSG":"P_NJ" 2.011 MB 10008 rows . . exported "LUBINSU"."SERV_MSG":"P_NT" 2.197 MB 10008 rows . . exported "LUBINSU"."SERV_MSG":"P_SQ" 1.996 MB 10008 rows . . exported "LUBINSU"."SERV_MSG":"P_SZ" 2.084 MB 10008 rows . . exported "LUBINSU"."SERV_MSG":"P_TZ" 1.951 MB 10008 rows . . exported "LUBINSU"."SERV_MSG":"P_WX" 2.059 MB 10008 rows . . exported "LUBINSU"."SERV_MSG":"P_XZ" 2.038 MB 10008 rows . . exported "LUBINSU"."SERV_MSG":"P_YC" 1.935 MB 10008 rows . . exported "LUBINSU"."SERV_MSG":"P_YZ" 1.819 MB 10008 rows . . exported "LUBINSU"."SERV_MSG":"P_ZJ" 1.927 MB 10008 rows . . exported "LUBINSU"."PROCEDURE_RESULT" 6.335 KB 15 rows . . exported "LUBINSU"."STAT_PROCEDURE" 46.99 KB 163 rows . . exported "LUBINSU"."TEACHER_VPN_STAT_DAILY" 80.25 KB 2377 rows . . exported "LUBINSU"."DEPT" 5.656 KB 4 rows . . exported "LUBINSU"."EMP" 7.820 KB 14 rows . . exported "LUBINSU"."LATN_AREA_INFO" 16.11 KB 14 rows . . exported "LUBINSU"."PO_SPEC_CATE_TREE_RELA" 24.95 KB 578 rows . . exported "LUBINSU"."TEACHER_VPN_STAT_DAILY_T" 9.937 KB 65 rows . . exported "LUBINSU"."SERV_MSG":"P_PROVINCE" 0 KB 0 rows Master table "LUBINSU"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded ****************************************************************************** Dump file set for LUBINSU.SYS_EXPORT_SCHEMA_01 is: /home/lubinsu/dpump/lubinsu.dmp Job "LUBINSU"."SYS_EXPORT_SCHEMA_01" successfully completed at 22:24:58 成功導出

Ⅳ 如何用sq腳本文件

用查詢器打開做行.sql文件後，如果.sql文件內容是類似select * from <表名慎李>的sql語句，則點擊上方綠色小三角（快捷鍵是F5）,就可以純孝嘩看到你想看的表中的數據了。

Ⅵ 如何訪問sqserver資料庫

1、打開sql2008，使用windows身份登錄

2、登錄後，右鍵選擇「屬性」。左側選擇「安全性」，選中右側的「搏冊腔SQL Server 和 Windows 身份驗證模式」以啟用混合登錄模式

3、選擇「連接」，勾選「允許遠程連接此伺服器」，然後點「確定」

4、展開「安全性」，「登錄名」;「sa」，右鍵選擇「屬性基衫」

5、左側選擇「常規」，右側選擇「SQL Server 身份驗證」，並設置密碼

6、右擊資料庫選擇「方面」

7、在右側的方面下拉框中選擇「伺服器配置」；將「RemoteAccessEnabled」屬性設為「True」，點「確定」

8、至此SSMS已設置完畢，先退出，再用sa登錄，成功即表示sa帳戶已經啟用

9、打開sql server配置管理器

10、下面開始配置SSCM，選中左側的「SQL Server服務」，確保右側的「SQL Server」以及「SQL Server Browser」正在運行

11、在左姿察則選擇sql server網路配置節點下的sqlexpress的協議，在右側的TCP/IP默認是「否」，右鍵啟用或者雙擊打開設置面板將其修改為「是」

12、選擇「IP 地址」選項卡，設置TCP的埠為「1433」

13、將"客戶端協議"的"TCP/IP"也修改為「Enabled」
配置完成，重新啟動SQL Server 2008。此時應該可以使用了，但是還是要確認一下防火牆。打開防火牆設置。將SQLServr.exe（C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Binn\sqlservr.exe）添加到允許的列表中。

Ⅶ 如何調取sqlist資料庫文件

1.首先你需要去下載一個 Navicat for SQLite ，散悔怎麼下載這里我不多說，你可以去網路搜索。最好下載綠色版。搜索 「Navicat for SQLite 綠色版」。

2.下載後，右擊軟體包進行解壓縮。

3.下載後雙擊文件夾，打開文件目錄，找到 navicat.exe 這個主程序，右擊在彈出菜單依次點擊【發送到(N)】--->【桌睜返面快捷方式】。

4.這時你的電腦桌面就多了一個 navicat.exe 的快捷方式圖標，以後需要打開，直接點擊這個快捷方式就可以了。

5.雙悉掘飢擊桌面快捷方式,打開軟體，在軟體左上角點擊【連接】按鈕,點擊後彈出新建連接對話框。

6.在彈出窗口中輸入【連接名】，選擇【類型】-然後在下面選擇資料庫文件，或者資料庫保存位置。

7.這樣就在你的指定位置創建了一個Sqlite資料庫文件了，有了這個資料庫文件你可以做任何資料庫的操作了。
​