List of Chapters
List of Chapters...................................................................................................................................2
Chapter 1 Brief introduction...............................................................................................................3
Preface.........................................................................................................................................3
Product characteristic..................................................................................................................4
Chapter 2 How to Install it.................................................................................................................6
Installation process......................................................................................................................6
Uninstall....................................................................................................................................11
Chapter 3 Basic operation.................................................................................................................13
Create ODBC Data source........................................................................................................13
Login.........................................................................................................................................14
Develop environment................................................................................................................15
How to use the Object view in DB Query Analyzer.................................................................18
How to know the DD well................................................................................................18
How to generate the familiar SQL statement, such as Top N statement..........................21
How to get the script of Stored Procedure........................................................................22
Chapter 4 Advanced operation..........................................................................................................23
Parameters Setting in DB Query Analyzer...............................................................................23
About transactions commit.......................................................................................................24
Illustration of transactions commit manually...........................................................................24
Set transactions commit manually....................................................................................24
Delete some records..........................................................................................................25
Rollback transactions........................................................................................................26
Commit transactions..........................................................................................................26
Cancel the script being executed...............................................................................................27
Run multi-SQL statement..........................................................................................................29
How to sort the result according to one field............................................................................30
How to export the result queried...............................................................................................32
How to Search the target words in the result queried...............................................................32
How to design efficient SQL Statement....................................................................................33
How to create Stored Procedure................................................................................................35
How to execute Stored Procedure.............................................................................................36
Chapter 5 Running environment.......................................................................................................37
Chapter 6 How to register the system...............................................................................................38
Chapter 7 Attention,please................................................................................................................41