| |
Home |
![[Table of Contents]](/dwicons/b_toc.gif)
|
ASA User's Guide |
![[-]](/dwicons/i_colpse.gif)
| Part 1 Working with Databases |
This part provides a manual for using Adaptive Server Anywhere that focuses on the mechanics of carrying out different tasks.
|
| Chapter 1: Running the Database Server |
![[+]](/dwicons/i_expand.gif)
| Introduction |
| Starting the server |
|
| Some common command-line switches |
|
| Stopping the database server |
| Loading and unloading databases |
|
| Running the server outside the current session |
|
| Troubleshooting server startup |
|
| Chapter 2: Connecting to a Database |
|
| Introduction to connections |
|
| Simple connection examples |
|
| Working with ODBC data sources |
|
| Connection parameters |
|
| Troubleshooting connections |
|
| Using integrated logins |
|
| Chapter 3: Working with Database Objects |
|
| Tools for working with database objects |
|
| Working with databases |
|
| Working with tables |
|
| Working with views |
|
| Working with indexes |
|
| Chapter 4: Queries: Selecting Data from a Table |
|
| Query overview |
|
| The SELECT clause: specifying columns |
| The FROM clause: specifying tables |
|
| The WHERE clause: specifying rows |
|
| Chapter 5: Summarizing, Grouping, and Sorting Query Results |
|
| Summarizing query results using aggregate functions |
|
| The GROUP BY clause: organizing query results into groups |
|
| Understanding GROUP BY |
| The HAVING clause: selecting groups of data |
|
| The ORDER BY clause: sorting query results |
| The UNION operation: combining queries |
|
| Standards and compatibility |
|
| Chapter 6: Joins: Retrieving Data from Several Tables |
|
| How joins work |
|
| How joins are structured |
| Key joins |
| Natural joins |
|
| Joins using comparisons |
|
| Inner, left-outer, and right-outer joins |
| Self-joins and correlation names |
|
| Cross joins |
|
| How joins are processed |
|
| Joining more than two tables |
| Joins involving derived tables |
|
| Transact-SQL outer joins |
|
| Chapter 7: Using Subqueries |
| What is a subquery? |
| Using Subqueries in the WHERE clause |
|
| Subqueries in the HAVING clause |
| Subquery comparison test |
|
| Quantified comparison tests with ANY and ALL |
| Testing set membership with IN conditions |
| Existence test |
| Outer references |
| Subqueries and joins |
| Nested subqueries |
|
| How subqueries work |
|
| Chapter 8: Adding, Changing, and Deleting Data |
|
| Data modification statements |
|
| Adding data using INSERT |
| Changing data using UPDATE |
|
| Deleting data using DELETE |
|
| Chapter 9: Using SQL in Applications |
| Executing SQL statements in applications |
|
| Preparing statements |
|
| Introduction to cursors |
|
| Types of cursor |
|
| Working with cursors |
| Describing result sets |
|
| Controlling transactions in applications |
|
| Chapter 10: Importing and Exporting Data |
|
| Import and export overview |
|
| Unloading and reloading a database |
|
| Exporting data from a database |
|
| Importing data into a database |
|
| Chapter 11: International Languages and Character Sets |
|
| Introduction to international languages and character sets |
|
| Understanding character sets in software |
|
| Understanding locales |
|
| Understanding collations |
|
| Understanding character set translation |
|
| Collation internals |
|
| International language and character set tasks |
|
|