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.内部类仍然是 ...
一周排行
  •   作为喜欢较真的程序开发者,一个最难以让我们接受的事实是,很多看起来开发和设计都几乎完美的软件却无人问津.相反,很多开发的一塌糊涂的软件却被世界上的人们大量的每天使用着,这些软件如果不是设计糟糕,就是bug多多.这 ...
  • 2007年12月29日,百度宣布CFO王湛生因意外辞世. 该职位一直空缺,由CEO李彦宏暂代.直到2008年3月31日现任CFO李昕晢加入百度任首席财务官.
  • 虽然老话说"酒香不怕巷子深",但在信息铺天盖地,新公司.新产品如雨后春笋的当下,做好品质的同时,懂得恰到好处的自我营销也是各大公司的必修课.移动互联网点燃了口碑营销,传统意义上的口口相传已经被互联 ...
  • 22.在计算机应用领域中,CAM是指 . 23.符号数的原码.补码和反码表示中,能惟一表示正零和负零的是 . 24.长文件名“计算机应用基础.DOC对应的短文件名是 . 25.在WINDOWS中,文件名的长度可达 个 ...
  • Network Defense Construction Without Delay   为维护我们国家的网络空间安全,必须加紧“网络国防”建设,加强“网络强军”步伐.   To maintain the safet ...
  • [email protected],是CSS入门学习中的基础知识,需要的朋友可以参考下 我们知道,css文件引入方式有两种:1. HTML中使用link标签 <link rel="styles ...
  • http://blog.csdn.net/dadalan/article/details/3983 http:[email protected]/blog/static/404330272010610 ...
  • 常用的类型: 1.数学: Math.ceil():天花板数 Math.floor():地板数 Math.round():四舍五入取整数 Math.random():生成之间的随机数   2.日期时间: var ...
  • xjr考考你数据结构(根号2) 难度级别:C: 运行时间限制:3ms: 运行空间限制:51200KB: 代码长度限制:2B 试题描述 请你编写一个数据结构,完成以下功能: 1)求出第L个到第R个数中的最大.最小值以及 ...
  • 一.工具介绍         Tcpcopy 是一个分布式在线压力测试工具,可以将线上流量拷贝到测试机器,实时的模拟线上环境,达到在程序不上线的情况下实时承担线上流量的效果,尽早发现 bug,增加上线信心.      ...