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.内部类仍然是 ...
一周排行
  • "我们要开实体店."当爱肯牛仔(下称"爱肯")的首席运营官向冀抛出这个话题时,华东理工大学商学院青年商业领袖行动会现场一下子喧闹起来.在公开场合将自己置身于争议之中,这对于爱肯 ...
  • 第一次用jsp写东西,在webroot子文件夹下写jsp,当提交到Servlet时报404错误,老以为是子文件的问题,其实不是. 事实是同学把这段代码给我删了,jsp文件无法找到根目录, [java] <%  ...
  • 菜鸟玩云计算之五:Ubuntu Server 12.10 安装接下来一路默认.直到出现软件安装选择.移动到要安装的软件上按空格选中.到此,ubuntu安装成功.(接下来如何创建KVM虚拟机?待续)
  • dulist.h声明文件 #ifndef _DuList_H #define _DuList_H struct DuLNode; typedef struct DuLNode *duLinkList; typedef ...
  • 注册会员-上传头像.asp-GIF89a绕过 www.2cto.com提示: 修复请参考本站前文 作者:CrackerMrX(感谢投稿)
  • 返回:贺老师课程教学链接下面的程序,用于命令行中给出的文件.请利用命令行的方式运行程序.#include<stdio.h> #include<string.h> int main(int ar ...
  • 2014,我的创业记忆片段 ----谨以此文献给<2013,我的创业记忆片段> 2013年底的一个周末的下午,我一人来到位于上海的办公室,坐下来,想了想,平静地写了<2013,我的创业记忆片段> ...
  • A 上市前期 启动大会 目的 各家机构与公司会面,了解公司大体的结构,比如管理架构.销售模式.运营模式,并考察项目是否可以承接. 参与机构 投资银行- 通常一个融资额在1.5亿美元的上市项目,需要2家联席账簿管理员( ...
  • 做过项目的人可能都会有这样的经历:一个项目做了很久,感觉总是做不完,就像一个“无底洞”.用户总是有新的需求要项目开发方来做,就像用户在“漫天要价 ”,而开发方在“就地还钱”.实际上,这里涉及到一个“范围管理”的概念. ...
  • https://github.com/tianqiq/CloudStore.git