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.内部类仍然是 ...
一周排行
  • 原文:http://www.ibm.com/developerworks/cn/java/j-lo-optmizestring/ Java 性能优化之 String 篇 String 方法用于文本分析及大量字符串处理 ...
  • 易网科技讯 UC浏览器开放平台商务负责人王振兴在易网科技主办的主题为"WebApp"的五道口沙龙中表示,WebApp与Native App一定是共存的,这其中的深层次原因在于,互联网巨头已经把移动 ...
  • a - "am" 或是 "pm"  A - "AM" 或是 "PM"  d - 几日,二位数字,若不足二位则前面补零; 如: " ...
  • package com.example.anothersignintest;   import java.io.IOException;   import com.google.android.gms.auth.Go ...
  • [java]  package com.sort2;    import java.util.Arrays;    public class SortUtil  {      //直接查找排序      public ...
  • 以下是我在看php视频教程时所做的一些简单的笔记 一 :Web开发分为 1.静态web开发(html页面) 2..动态web开发. 发帖,网上支付,发短信,发邮件. Php是嵌入到html代码中,php脚本运行在服务 ...
  • page.ClientScript.RegisterStartupScript(page.GetType(), "msg", "<script>alert('" + ...
  •        很高兴,你阅读此篇我自己整理的文章,首先需要说明一下,此篇文章适合初学和刚接触DB2的开发人员阅读,如果你自认觉得能力很好,可以绕开.       此篇文章也是结合我实际经验对其进行整理,也是自己的一个 ...
  •   项目中用到的验证身份证号码的工具类,和大家分享一下!可以验证16位和18位的身份证号码. import java.text.SimpleDateFormat; import java.util.Calendar; ...
  • GPIO_InitTypeDef GPIO_InitStructure2;        TIM_TimeBaseInitTypeDef TIM_TimeBaseStructure;        TIM_OCIni ...