• Table of Contents• Index• Reviews• Reader Reviews• Errata• AcademicSQL in a Nutshell, 2nd EditionBy Kevin E. Kline Publisher: O''ReillyPub Date: September 2004ISBN: 0-596-00481-8Pages: 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