SQLDBX微小型数据库管理软件资源-CSDN文库

共31个文件

dll：12个

pdb：7个

lib：3个

SQLDBX

数据库管理工具

需积分: 3 112 浏览量 2023-02-13 21:11:46 上传评论收藏 10.43MB RAR 举报

资源推荐

资源详情

资源评论

收起资源包目录

SqlDbx4.17.rar （31个子文件）

SqlDbx4.17

myodbc5w.dll 4.86MB

pgenlista.pdb 628KB

myodbc5S.lib 2KB

myodbc5a.lib 17KB

._SqlDbx.pdf 4KB

libcrypto-1_1.dll 2.12MB

._SqlDbxU_zhcn.exe 4KB

psqlodbc35w.pdb 1.89MB

myodbc5a.pdb 5.18MB

SqlDbx_C.exe 2.33MB

SqlDbxU_zhcn.exe 2.71MB

libssl-1_1.dll 518KB

myodbc5S.dll 4.04MB

libpq.dll 247KB

myodbc5S.pdb 2.02MB

myodbc5w.lib 18KB

vcruntime140.dll 81KB

msvcp140.dll 443KB

myodbc5a.dll 4.87MB

SqlDbx_C.rar 839KB

psqlodbc35w.dll 489KB

pgenlista.dll 24KB

SqlDbx.chm 129KB

psqlodbc30a.dll 477KB

pgenlist.dll 24KB

psqlodbc30a.pdb 1.85MB

lang.txt 22KB

myodbc5w.pdb 5.18MB

pgenlist.pdb 628KB

._lang.txt 4KB

SqlDbx.pdf 835KB

SqlDbx

Table of Contents

1. Overview of SqlDbx ......................................................................................................................... 3

2. Using SqlDbx ................................................................................................................................... 3

2.1 Quick Start................................................................................................................................. 4

2.2 Editor Keyboard Shortcuts ........................................................................................................ 4

2.3 Results Grid Keyboard Shortcuts .............................................................................................. 7

2.4 SQL Script Editor ....................................................................................................................... 9

2.5 Intellisense ................................................................................................................................ 9

2.6 SQL Templates ........................................................................................................................ 10

2.7 Speed Typing ........................................................................................................................... 10

2.8 Visual Diff ................................................................................................................................ 11

2.9 Export / Import ....................................................................................................................... 11

2.10 Generate Scripts ................................................................................................................... 11

2.11 Server Explorer ...................................................................................................................... 11

2.12 Options .................................................................................................................................. 12

2.13 Command Line Options ........................................................................................................ 12

2.14 Quick Tips .............................................................................................................................. 12

3. Script Editor .................................................................................................................................. 13

3.1 Editing Scripts.......................................................................................................................... 13

3.2 Executing Scripts ..................................................................................................................... 13

3.3 Script Variables ....................................................................................................................... 14

3.4 Script Commands .................................................................................................................... 15

4. Object View ................................................................................................................................... 16

4.1 Working with Object View ...................................................................................................... 16

4.2 Execute Procedures / Functions ............................................................................................. 17

5. Results View .................................................................................................................................. 18

5.1 Results Grid ............................................................................................................................. 18

6. Options .......................................................................................................................................... 20

6.1 General .................................................................................................................................... 20

6.2 Editor ....................................................................................................................................... 20

6.3 Colors ...................................................................................................................................... 21

6.4 Results ..................................................................................................................................... 21

6.5 Scripting .................................................................................................................................. 22

6.6 Import / Export ....................................................................................................................... 22

6.7 Servers .................................................................................................................................... 23

7. Oracle Help.................................................................................................................................... 23

7.1 Oracle How To ......................................................................................................................... 23

7.2 Bind Variables ......................................................................................................................... 24

7.3 SQL*Plus commands ............................................................................................................... 24

8. Microsoft SQL Server Help ............................................................................................................ 24

8.1 Sql Server How To ................................................................................................................... 25

9. Sybase Help ................................................................................................................................... 25

9.1 Sybase How To ........................................................................................................................ 25

SqlDbx

10. IBM DB2 Help .............................................................................................................................. 25

10.1 DB2 How To .......................................................................................................................... 26

11. Informix Help .............................................................................................................................. 27

12. Teradata Help .............................................................................................................................. 27

13. MySQL Help ................................................................................................................................. 27

14. PostgreSQL Help.......................................................................................................................... 27

15. Kdb+ Help .................................................................................................................................... 28

16. ODBC Help ................................................................................................................................... 28

16.1 ODBC How To ........................................................................................................................ 28

17. Change Log .................................................................................................................................. 28

SqlDbx

1. Overview of SqlDbx

Welcome to SqlDbx

SqlDbx is database administration and SQL development IDE focused on application developers

who work in heterogeneous database environments.

Features at a glance:

 High performance native support for major Database Servers including Microsoft, Sybase,

Oracle and IBM DB2/UDB

 Browse / Explore Servers

 Fast, intelligent, extensive and highly customizable Intellisense

 Advanced script Editor with Syntax highlighting, Auto Complete, Speed Typing, Drag/Drop,

Undo/Redo, Find/Replace

 Unicode support

 Visual Data Diff

 SQL Scripting

 SQL Formatter / Beautifier

 Generate SELECT, INSERT, UPDATE, DELETE, WHERE IN data modification statements

directly from result grid

 SQL templates with replaceable formal parameters

 Import / Export to CSV, XML, Excel

 Schema object browser

 SQL statement history

 Favorite objects

 Search in Database and in Result grid

 Directly edit table data in Result grid

 Display query plan and query statistics

 Simple deployment and removal. No dll's or other dependencies. Just one executable (1.4

meg.)

Supported DBMS Systems

 Oracle ® 8i - 11g

 Microsoft ® SQL Server 6.5 - 2008

 IBM DB2 LUW ® 7.x - 9.x

 IBM DB2 z/OS ® 7.x - 9.x

 IBM DB2 iSeries ® 5.x - 7.x

 Sybase ASE ® 10.x - 15.x

 Sybase Anywhere ® 9.x - 12.x

 Sybase IQ ® 12.5 - 15.x

 MySQL ® 5.x

 Kdb+ ®

 ODBC 3.0 compliant sources

2. Using SqlDbx

SqlDbx window divided into three views: Object View, Script Editor and Results View

Editor Shortcuts

Grid Shortcuts

SQL Script Editor

Intellisense

Script Variables

SQL Templates

Speed Typing

Visual Diff

Export / Import

SqlDbx

Generate Scripts

Server Explorer

Options

Command Line options

2.1 Quick Start

When You start SqlDbx it automatically shows Server Login dialog. Select correct Server type, enter

Server name, Database, User and Password and click button Login. If server found and client

software installed correctly new SQL Editor window will open.

Set Alias button can be used to create alternate user friendly name for the Server. Also it is useful

when you connect to the same server using different credentials. "Production" check box allows to

specify alternate text and background colors. This allows to visually differentiate between

production and development Servers. Set Alias button allows to create multiple aliases for the

same Server. You can create it by directly typing into Server combo box. Make sure that actual

Server name enclosed between "(" and ")"

Using SqlDbx

SqlDbx portable

If you wish to use SqlDbx in portable mode create empty SqlDbx.ini file in a same directory where

SqlDbx.exe located. After you start SqlDbx it will run in portable mode.

In this mode SqlDbx will not make any changes to registry or create directories / files on a

computer.

2.2 Editor Keyboard Shortcuts

Load / Save

Ctrl + N

New Script

Ctrl + O

Open file

Ctrl + S

Save active script

Ctrl + Shift + S

Save active script with different name

Ctrl + W

Close active script tab

Ctrl + Shift + W

Close active Result tab

Cursor Movement

Left

Move cursor one character left

Right

Move cursor one character right

Move cursor one line up

评论收藏

内容反馈

RealName-Wang

粉丝: 85
资源: 21

SQLDBX微小型数据库管理软件

SQLDBX数据库管理工具

SqlDbx数据库管理

SQLDBX 数据库界面工具

SqlDbx 简易数据库

SqlDbx 3.6数据库管理工具

SQLDBX 连接多种类型的数据库

SqlDbx数据库数据管理

SqlDbx_C数据库工具

Sqldbx 数据库客户端工具

sqldbx3.5数据库工具

SQL工具SqlDbx

plsql+sqlDbx数据库连接工具

SQLDBX.rar

SqlDbx数据库访问工具

数据库管理工具+SqlDbx 6.16+中文+专业版.7z

SqlDbx连接oracle

SQL数据库连接工具SqlDbx

数据库连接工具sqldbx

SqlDbx中文版.zip

数据库上传工具sqldbx

sqlDbx 连接Sybase数据库

数据库工具SqlDbx

SqlDbx，数据库连接操作工具，绿色

SqlDbx多标签

SqlDbx 数据库连接工具 可连接多个数据库

sqlDbx连接数据库，不用安装Oracle客户端

SqlDbx.zip

dm8-20240710-x86-win-64.zip

2023年更新的最新版全国五级行政区域数据库表以及sql文件

2024最新手机归属地数据库mysql,近49w条数据

最新资源

SqlDbx 数据库连接工具可连接多个数据库