DB Query Analyzer specification.docVIP

DB Query Analyzer Specification List of Chapters List of Chapters 2 Chapter 1 Brief introduction 3 Preface 3 Product characteristic 4 Chapter 2 How to Install it 5 Installation process 5 Uninstall 9 Chapter 3 Basic operation 12 Create ODBC Data source 12 Login 13 Develop environment 14 How to use the Object view in DB Query Analyzer 17 How to know the DD well 17 How to generate the familiar SQL statement, such as Top N statement 19 How to get the script of Stored Procedure 20 Chapter 4 Advanced operation 21 Parameters Setting in DB Query Analyzer 21 About transactions commit 22 Illustration of transactions commit manually 22 Set transactions commit manually 22 Delete some records 23 Rollback transacitons 24 Commit transactions 24 Cancel the script being executed 25 Run multi-SQL statement 27 How to sort the result according to one field 28 How to export the result queried 29 How to Search the target words in the result queried 29 How to design efficient SQL Statement 30 How to create Stored Procedure 31 How to execute Stored Procedure 32 Chapter 5 Running environment 33 Chapter 6 How to register the system 34 Chapter 1 Brief introduction Preface From the generation of Relative Database Management System, There are many production of RDBMS presented, such as Oracle, Sybase, DB2, Informix, MS SQL Server, Mysql, MS ACCESS, FoxPro and Paradox. For their characteristic and price advantage, they have their own market. Every production of RDBMS has a tool to access Database，which based on Client/Server. But it is too difficult to control over it because the great difference in interface and function among them. What is more, some client tools are not friendly. Nowadays, The beginner, developer and maintenance person of RDBMS are suffering from the client tools according to different RDBMS for the two reasons followed. One is that it is very common to use above one production of RDBMS. The other is that different name of one function which imp