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.内部类仍然是 ...
一周排行
  • CityEngine中不支持弧段的存储,各种面都是折线面,也就是ArcGIS中的Polygon.当遇到圆柱体的建筑物或实体时,如何为其建模呢?        考虑到ArcGIS与CityEngine的数据是可以互操作 ...
  • 根据thenextweb的报道,三星电子产品战略团队高级副总裁Yoon Han-kil近日表示,将在今年第二季度发布基于Tizen系统的智能手机. Yoon Han-kil向媒体透露,三星正在着手推出至少两款基于Ti ...
  • 易网科技讯 2月22日消息,根据EnfoDesk易观智库近期发布的<2011年第4季度中国移动终端市场季度监测>调研数据显示, Android产品占中国整体智能手机销量的68.4%.2011年中国手机市场 ...
  • 错误的估计和不当的评价标准 无软件历史数据和度量数据 没有使用正式的配置控制 手工设计和规格说明 非正式和不充分的测试 没有使用自动化的评估工具 没有使用计划工具 缺乏跟踪.对里程碑缺乏监督 架构问题 开发方法问题 ...
  • ORACLE自学笔记   Oracle中3个默认用户 sys        change_on_install  [as sysdba] system  manager scott     tiger 数据字典 查看 ...
  • 版权声明:原创作品,允许转载,转载时请务必以超链接形式标明文章原始出版.作者信息和本声明.否则将追究法律责任.http://blog.csdn.net/topmvp - topmvpWritten by the Mi ...
  • 新华社记者章苒.张遥.裘立华本来,石头桥.摇橹船和袅袅炊烟已经像代码一样写进江南古镇的生活程序,执行了千年似乎都不用更新.不过,一群来自互联网热土的预言家们宣布,他们已经看见了未来的样子.他们为"未来会是什 ...
  • 最近工作比较轻松,也学习C#  zy11.了解C#的诞生和特点.2.认识C#的开发环境(Visual Studio 2010).3.掌握C#代码的编写.运行过程.4.重点掌握主函数和函数的用法.5.重点掌握行注释和块 ...
  •   属性->配置属性->C/C++->优化   优化 /Od,/O1,/O2,/Ox   C/C++->基本运行时检查  两者(/RTC1,等同于/RTCsu)     优化禁用 ml.exe ...
  • DNF商人经验分享 教你怎样成为一名合格的商人 前言,最近闲的无聊,常常挂机,手头又有点游戏币,突然间对游戏里的商人充满了兴趣.于是自己研究了一下,算是小有成就吧.特地拿出来与大家分享.希望对新手有帮助,对高手有启发 ...