| SQL in a Nutshell, 2nd Edition |
| By Kevin E. Kline |
| |
| Publisher | : O'Reilly |
| Pub Date | : September 2004 |
| ISBN | : 0-596-00481-8 |
| Pages | : 710 |
| | | |
| | Copyright |
| | | Preface |
| | | | Why This Book? |
| | | | Who Should Read This Book? |
| | | | How This Book Is Organized |
| | | | Conventions Used in This Book |
| | | | How to Use This Book |
| | | | How to Contact Us |
| | | | Safari Enabled |
| | | | Resources |
| | | | Changes in the Second Edition |
| | | | Acknowledgments |
| | | Chapter 1. SQL History and Implementations |
| | | | Section 1.1. The Relational Model and ANSI SQL |
| | | | Section 1.2. History of the SQL Standard |
| | | | Section 1.3. SQL Dialects |
| | | Chapter 2. Foundational Concepts |
| | | | Section 2.1. Database Platforms Described in This Book |
| | | | Section 2.2. Categories of Syntax |
| | | | Section 2.3. SQL2003 and Platform-Specific Datatypes |
| | | | Section 2.4. Constraints |
| | | Chapter 3. SQL Statement Command Reference |
| | | | Section 3.1. How to Use This Chapter |
| | | | Section 3.2. SQL Platform Support |
| | | | Section 3.3. SQL Command Reference |
| | | Chapter 4. SQL Functions |
| | | | Section 4.1. Types of Functions |
| | | | Section 4.2. ANSI SQL Aggregate Functions |
| | | | Section 4.3. ANSI SQL Window Functions |
| | | | Section 4.4. ANSI SQL Scalar Functions |
| | | | Section 4.5. Platform-Specific Extensions |
| | | Chapter 5. Database Programming |
| | | | Section 5.1. Database Programming Overview |
| | | | Section 5.2. Opening a Database Connection |
| | | | Section 5.3. Closing a Database Connection |
| | | | Section 5.4. Managing Transactions |
| | | | Section 5.5. Executing Statements |
| | | | Section 5.6. Retrieving Data |
| | | | Section 5.7. Bound Parameters |
| | | | Section 5.8. Error Handling |
| | | | Section 5.9. Examples |
| | | Appendix A. Sybase Adaptive Server |
| | | | Section A.1. Sybase Adaptive Server Datatypes |
| | | | Section A.2. Sybase Adaptive Server SQL Statements |
| | | | Section A.3. Sybase Adaptive Server SQL Functions |
| | | | Section A.4. Sybase Adaptive Server Keywords |
| | | Appendix B. Shared and Platform-Specific Keywords |
| | | Colophon |
| | | Index |