List of Chapters
List of Chapters...................................................................................................................................2
Chapter 1 Brief introduction...............................................................................................................4
1.01 Preface.................................................................................................................................4
1.02 Product characteristic..........................................................................................................6
1.03 Achievement of DB Query Analyzer..................................................................................8
1.04 Development of DB Query Analyzer..................................................................................9
1.05 new characteristic in version 4.01.....................................................................................10
1.06 new characteristic in version 4.02.....................................................................................11
1.07 new characteristic in version 4.03.....................................................................................11
1.08 new characteristic in version 5.01.....................................................................................12
1.09 new characteristic in version 5.02.....................................................................................12
1.10 new characteristic in version 5.03.....................................................................................12
1.11 new characteristic in version 5.04.....................................................................................12
1.12 new characteristic in version 5.05.....................................................................................12
1.13 new characteristic in version 6.01.....................................................................................12
1.14 new characteristic in version 6.02.....................................................................................13
1.15 new characteristic in version 6.03.....................................................................................13
Chapter 2 Install/Uninstall Process..................................................................................................15
2.1 Installation process..............................................................................................................15
2.2 Uninstall..............................................................................................................................22
Chapter 3 Basic operation.................................................................................................................24
3.1 Create ODBC Data source..................................................................................................24
3.2 Login...................................................................................................................................24
3.3 Develop environment..........................................................................................................25
3.4 How to use the Object view in DB Query Analyzer...........................................................28
3.5 How to know the DD well..................................................................................................28
3.6 How to generate the familiar SQL statement, such as Top N statement............................31
3.7 How to get the script of Stored Procedure..........................................................................32
Chapter 4 Advanced operation..........................................................................................................34
4.01 Parameters Setting in DB Query Analyzer.......................................................................34
4.02 About transactions commit................................................................................................35
4.03 Illustration of transactions commit manually...................................................................35
4.031 Set transactions commit manually..........................................................................35
4.032 Delete some records................................................................................................36
4.033 Rollback transactions..............................................................................................37
4.034 Commit transactions...............................................................................................38
4.04 Cancel the script being executed.......................................................................................39
