The 9th tip of SQL design by DB Query Analyzer

 

 

The 9th tip of SQL design by DB Query Analyzer

MA Gen-feng  

           ( GuangDong Unitoll Services incorporated, GuangZhou 510300)

 

My blogs are

http://blog.csdn.net/magenfeng

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

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

 

 
 
 

0    Briefintroduction of DB Query Analzyer  

     DB Query Analyzer is presented by Master Gen feng, Ma from Chinese mainland. It has English version and Simplified Chinese version.
 

  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 presented to the world In 2007. From then on, The continuous improvement of function or interface has been done. Now the latest version is 3.02.
 

  Untill now it has been downloaded about ninety thousand times in the famous software download website http://xiazai.zol.com.cn/. It is one of the twenty most frequently download software. 
 

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

  By November 9, 2009 ,you would get 1500 thousand result with the key word ‘DB Query Aanlyzer’ in Google. In Baidu you would get 40 thousand result.
 

 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.
 

  I will show you how to program SQL quickly by DB Query Analyzer 3.02.
 

OS : WIN7

Database system : MS ACCES 2008

Client tool : DB Query Analyzer 3.02.

 

 

 

1    Preface
 

 In DB Query Analyzer 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 in all the opened windows right now. If you reset the ‘Export result to file with title’ configuration window, it also will take effect in all the opened windows right now. However, If you reset the separator between SQL, it will take effect in the new opened SQL edit window.
 

I will show you how to avoid display error which takes place when file contain 0AH charator is opened by EXCEL . 

OS : WIN7

Database system : MS ACCES 2008

Client tool : DB Query Analyzer 3.02.

 


 

2    Create the DSN based on MS ACCESS
 

RunDB Query Analyzer 3.02 first, then click the sub menu ‘ODBC Data Source Management’ of menu ‘Tools(s)’ to create DSN four_stations based on MS ACCESS.
 

This is shown in Figure 1.
 

 

Figure 1  create DSN four_stations based on MS ACCESS

 

Click ‘File’ menu to choose ‘Connect’ to connect to the ODBC DSN four_stations.

 

 
 

3    Export file with single quotation marks
 

Now set single quotation mark as the restrict character.

 

Click tools menu, then click configurations. Select single quotation marks in the drop-down list box in the configuration window. Then press F5 or click Run submenu of Query menu, you can get the result as figuration below.

 

Figure2  Display the result in Grid after set single quotation mark as the restrict character

 

Click the sub menu ‘Display’ of menu ‘Query(Q)’ and select Text. Then press F5 or click Run submenu of Query menu, you can get the result display in text as figure below.

 

Figure3  Display the result in Grid after set single quotation mark as the restrict character

 

But when you export the result to file and open it with EXCEL, you will find the record which listno equals ‘12036101152002040004’ display in two rows.

 

Figure4  Open the exported file with EXCEL

 

When you open the exported file with UltraEdit,youwill find a charater that ASCII CODE is 0AH within the word Luogang.

 

Figure 5  A character that ASCII CODE is 0AH within the word Luogang.

 

 

4        Export file with doublequotation marks
 

Click tools menu, then click configurations. Select double quotation marks in the drop-down list box in the configuration window. 

 

Figure 6  set double quotation mark as the restrict character

 

Then press F5 or click Run submenu of Query menu, you can get the result as figure below.

 

图7  Result display in Grid after set double quotation mark as the restrict character

 

Export the result to file and open it with EXCEL, you will find the record which listno equals ‘12036101152002040004’ display in one row.

 

图8    Open the exported file with EXCEL

 

 

    

  

 

 

 

 

 

 

 

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.