The ninth skills of SQL design by DB Query Analyzer.docVIP

The ninth skills of SQL design by DB Query Analyzer MA Gen-feng ( GuangDong Unitoll Services incorporated, GuangZhou 510300) My blogs are /magenfeng /magenfeng /630414817 Brief introduction 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 /. 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. 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