The 6th tip of DB Query Analyzer

The 6th tip of DB Query Analyzer

 

The 6th tip of DB Query Analyzer

MA Gen feng  

(Guangdong Unitoll Services incorporated, Guangzhou 510300)

 

Abstract   DB Query Analyzer provides ‘Object View’ by which you can get well know of DD in databases.

        I will show you how to get the fields in some table through the ‘Object View’.             

Key words   DB Query Analyzer

1    Brief introduction of DB Query Analzyer  

DB Query Analyzer is presented by Master Gen feng, Ma from Chinese Mainland. It has English version named ‘DB Query Analyzer’ and Simplified Chinese version named ‘万能数据库查询分析器(DB 查询分析器)’.
 

Master Gen feng Ma, the developer of DB Query Analyzer, hopes he can cooperate with some software company such as Sybase, Embarcadero, Microsoft and so on. He thinks it will be the better way that DB Query Analyzer is assembled in the develop tools according to such software company so that more and more database application software developer will benefit from its powerful function, friendly interface, easy operation and applicability to every production of RDBMS.

 

 

Achievement of DB Query Analyzer

In the New products & Tools reviews of programmer second issue of 2007, DB Query Analyzer had been strongly recommended.
 

Now DB Query Analyzer is the top 50 database application software in the famous software website http://xiazai.zol.com.cn/download_order/sub_550.html . In most case it lies the top 20 and it has been download more than 92,000 times.
 

By April 17st, 2013, you’ll get 3.18 million results if you search ‘万能数据库查询分析器’ in Baidu.com.
 

   By April 17st, 2013, you’ll get 1.04 million results if you search ‘DB 查询分析器’ in Baidu.com and you’ll get 0.16 million results if you search ‘DB Query Analyzer’ in Baidu.com
 

By April 17st, 2013, you’ll get 1.04 million results if you search ‘DB 查询分析器’ in google.com and you’ll get 0.44 million results if you search ‘DB Query Analyzer’ in Baidu.com

 

Development of DB Query Analyzer

After four years research, design, development and about three months integrated test based on Oracle, Sybase, DB2, Informix, MS SQL Server, MYSQL, MS ACCESS, FoxPro and Paradox, DB Query Analyzer is distributed to the world In 2007. From then on, the continuous improvement of function or interface has been done.

 

From version 2.0EXE Packer isn't be used to prevent DB Query Analyzer from being debugged. It will be never judged as virus foolishly.  
 

From version 3.01, it becomes free.
 

In version 3.02,it allows users to define the restrict character among single quotation marks, double quotation marks and none. If you reset it in the configuration window, the query result will take effect right now. However, If you reset the separator between SQL, it will take effect in the new opened SQL edit window.
 

From version 4.01, a useful function is added. Users can save the result with too many records into file in high efficiency.           
 

Version 4.03 and version 5.01 are the perfect version as a few little BUG that have been found are solved. On the other side, the flow of Installation Program is optimized.

    

Out of question, DB Query Analyzer is one of the few excellent Client Tools in the world for its’ powerful function, friendly interface, easy operation and applicability to every production of RDBMS.

 

 

 

2    Preface

DB Query Analyzer provides ‘Object View’ by which you can get well know of DD in databases.
 

After Expand the node of ODBC Data source in Object view, you can see five node System Tables, User Tables, Views, Aliases, Temporary Tables, Procedures/Functions.
 

   I will show you how to get the fields in some table through the ‘Object View’.
 

OS :  Windows XP / Windows 2000 Server
 

Database system : MS SQL Server, MYSQL
 

Client tool : DB Query Analyzer 5.01.

 

 

 

3    Connect to ODBC DSN based on MS SQL Server  

Run DB Query Analyzer 5.01 first, then click ‘File’ menu to choose ‘Connect’ to open the logging window. Select ODBC Data Source ‘test_sqlserver’, then input user name and password.

 This is shown in Figure 1.

  The 6th tip of DB Query Analyzer
Figure 1   ‘Connect’ to ODBC Data Source ‘test_sqlserver’

 

 

 

4     Get fileds by ‘Object View’

If you have privilige to get the DD of database, you can expand the ‘Object View’ to

get all the fields of some table.

 

This is shown in Figure 2.

 

The 6th tip of DB Query Analyzer

Figure 2   Get the fields information after expanding the ODBC DSN connected

 

Right click the table in the ‘Object View’, a popup menu helps you to generate frequent SQL Statement.

This is shown in Figure 3.

 

The 6th tip of DB Query Analyzer

Figure 3   Fetch the first 100 rows records

 

 

 

 

5    Without privilige to access the DD of databases

If you have no privilige to access the DD of databases, How to generate SQL statements quickly?

I will show you an example after connected to a MYSQL DSN. In this example, DB Query Analyzer is running on Windows XP.

Firstly, please select text in the menu Query(Y)-àDisplay--àText, This is shown in Figure 4.

 The 6th tip of DB Query Analyzer

Figure 4   Select Text item in the menu

 The 6th tip of DB Query Analyzer

    Figure 5   Another way select Text item

 

 

 The 6th tip of DB Query Analyzer

Figure 6   Execute the SQL statement

 

 

   After execute the SQL statement, select all fields name in the result area. Then copy them to the clipboard.

 

 

The 6th tip of DB Query Analyzer

Figure 7   Paste all fields name from clipboard and design the SQL statement

 

 

 

 

 

 

 

DB Query Analyzer 5.03 download URL:
http://xiazai.zol.com.cn/detail/43/420901.shtml
http://www.unitedpowersoft.com/UpFile/DBQueryAnalyzer_English_503.rar
 

 

DB Query Analyzer Simplified Chinese version 5.03  download URL:
http://xiazai.zol.com.cn/detail/27/264455.shtml
 
 

 

 

 

Remarks :

Please uninstall the former version first, then install the latest version.

 

 

 

My blog is http://blog.csdn.net/magenfeng

http://blog.sina.com.cn/magenfeng

         http://user.qzone.qq.com/630414817

 

 

 

 

 

 

 

 

 

更多相关文章
  • 一个系统查询接口存在未授权访问~   #!/usr/bin/env python # coding: utf-8 # pip install requests requests_ntlm import requests import re import sys import time from re ...
  • #!/usr/bin/env python -W ignore::DeprecationWarning    """       VBay <= 1.1.9 - Remote Error based SQL Injection                    ...
  • 前言:服务器这几天都连不上,所以迟迟未更新,今天连上后才把插件文件和文档上传了.良心之作啊,难度虽不高,但命名多文件多啊.我得马上写篇博客絮叨一下,直接上地址. 文档及下载地址:www.chengguanhui.com/demos/loading-js/ 1.简介 loading.js是本人近日开发 ...
  • wireshark的抓包方法上一相关博文已经详细做了介绍,其实关于wireshark来说,比较重要的还是数对抓包之后的“查询统计分析”,如何在海量的数据包中,抓取出自己关注的数据包是处理问题的第一步,今天这篇博文主要讲解如何进行“简单”的抓包筛选. 为了直观,本篇博文以一次实例进行,我在本地对网卡进 ...
  • 文/赵武 1月21日下午3点10分左右,国内通用顶级域的根服务器忽然出现异常,大量网站域名被劫持到65.49.2.178这个IP地址,导致全国约三分之二的网站DNS服务器解析失败,高达数千万网友无法顺利上网. 这是中国互联网历史上又一次空前的重大安全事故,影响之广和潜在的危险之大足以警醒中国互联网界 ...
  • Java语法总结 - 内部类 从Java1.1开始引入了内部类以来,它就引起了人们的激烈争论.其实任何优秀的语言特性用得不好就是滥用,内部类用得不好就会导致代码像迷宫一样,导致出现毫无重用的综合征. 1.内部类分为成员内部类.静态嵌套类.方法内部类.匿名内部类. 几种内部类的共性: A.内部类仍然是 ...
一周排行
  • 图像的阈值处理一般使得图像的像素值更单一.图像更简单.阈值可以分为全局性质的阈值,也可以分为局部性质的阈值,可以是单阈值的也可以是多阈值的.当然阈值越多是越复杂的.下面将介绍opencv下的三种阈值方法. (一)简单 ...
  • 第四代编程语言,或者说是第四阶段的编程语言,这是我自己理解定义的一个概念,请勿告诉我说4gl是SQL. 个人认为,对程序员而言,编程语言已经发展到第四个阶段了. 第一阶段,汇编语言.在此之前,还有机器语言,即0101 ...
  • 首先让我们了解一下大师们对"云计算"的经典看法: 比尔·盖茨1989年在谈论"计算机科学的过去现在与未来时"时说:"用户只需要640K的内存就足够了."那时 ...
  • //取出路径中文件名 'F:\\软件\\Adobe CS6\\Adobe CS6\\asdfasdf.jpg.txt'.replace(/.*\\(.*)\..*/,'$1')   匹配html属性 alt=(['& ...
  • 源自 心碎逍遥的博客 http://blog.sina.com.cn/s/blog_4b5bc0110100g22w.html 讲得非常清楚,很值得一看.   用JAVA获取文件,听似简单,但对于很多像我这样的新人来 ...
  • 经反复实验,发现OracleMTSRecoveryService服务使用端口1521,而这个端口默认是oracle数据库访问的监听端口.所以有两个办法,一是改变oracle数据库访问的监听端口,二是改变OracleM ...
  •        最近在复习数据结构,顺便看看大一的时候写的代码,看完之后比当初有了更加深刻的体会.         希望这些能提供给初学者一些参考. //链队列的类型描述 typedef struct Qnode { ...
  •   1      前言 这篇文章是我个人的学习笔记,我把这篇文章送给所有喜欢PHP语言,喜欢PHP扩展开发的同行.同学们.   2      前期准备 闲话不和大家撤了,如果您想学习php的扩展开发,相信您对php基 ...
  • 前面我们谈到了,可用通过异或运算交换两个数,而不需要任何的中间变量. 如下面: void exchange(int &a, int &b) {     a ^= b;     b ^= a;     ...
  • 每经记者 李卓 发自北京随着"双十一"最后倒计时,今年5月底成立以来一直低调的菜鸟网络,终将揭开神秘面纱.昨日(11月7日),阿里方面宣布,"双十一"期间所有的物流保障,与全国 ...