SQL in a Nutshell : A Desktop Quick Reference

by Kline, Kevin E.

• ISBN13: 9780596004811
• ISBN10: 0596004818
• Edition: 2nd
• Format: Paperback
• Copyright: 2004-10-30
• Publisher: Oreilly & Associates Inc

Summary

SQL in a Nutshell is a practical and useful command reference to the latest release of the Structured Query Language (SQL). For experienced SQL programmers, analysts, and database administrators, it's a handy key to each of the SQL commands and how to use it in both commercial (Oracle, DB2, and Microsoft SQL Server) and open source implementations (PostgreSQL, and MySQL). SQL in a Nutshell is also a great learning resource for novice and auxiliary SQL users such as system administrators.

Author Biography

Kevin Kline is the Technical Strategy Manager for SQL Server Solutions at Quest Software, a leading provider of award winning tools for database management and application monitoring tools. Kevin is also a founding board member and former President of the international Professional Association for SQL Server (PASS) and frequently contributes to database technology magazines, web sites, and discussion forums. Kevin's most popular book is SQL in a Nutshell published by O'Reilly Media. Kevin is also the author of monthly magazine columns for SQL Server Magazine and Database Trends & Applications. Kevin is a top rated speaker, appearing at international conferences like Microsoft TechEd, DevTeach, PASS, Microsoft IT Forum, and SQL Connections.

Table of Contents

Preface	vii
SQL History and Implementations	1	(15)
The Relational Model and ANSI SQL	2	(7)
History of the SQL Standard	9	(5)
SQL Dialects	14	(2)
Foundational Concepts	16	(41)
Database Platforms Described in This Book	16	(1)
Categories of Syntax	17	(12)
SQL2003 and Vendor-Specific Datatypes	29	(20)
Constraints	49	(8)
SQL Statement Command Reference	57	(416)
How to Use This Chapter	57	(1)
SQL Platform Support	58	(3)
SQL Command Reference	61	(412)
SQL Functions	473	(117)
Types of Functions	473	(1)
ANSI SQL Aggregate Functions	474	(18)
ANSI SQL Window Functions	492	(9)
ANSI SQL Scalar Functions	501	(22)
Platform-Specific Extensions	523	(67)
Database Programming	590	(31)
Database Programming Overview	591	(2)
Opening a Database Connection	593	(4)
Closing a Database Connection	597	(1)
Managing Transactions	597	(4)
Executing Statements	601	(2)
Retrieving Data	603	(5)
Bound Parameters	608	(6)
Error Handling	614	(2)
Examples	616	(5)
A. Sybase Adaptive Server	621	(14)
B. Shared and Platform-Specific Keywords	635	(10)
Index	645