* Gives programmers two-in-one coverage, with both a "how-to" onSQL functions and a complete SQL functions reference* SQL is the standard language for database queries; this book'sadvanced coverage helps programmers write their own SQLfunctions* Covers both the internationally standardized SQL 99 functionsand the hundreds of additional functions introduced by vendors,including the subtle variations required to successfully migrate orinteroperate between vendor products* Covers the latest versions of the major relational databasemanagement system (RDMS) applications: Microsoft SQL Server,Oracle, IBM DB2, and MySQL

Acknowledgments.Introduction.Chapter 1: Exploring Popular SQL Implementations.Chapter 2: Functions: Concept and Architecture.Chapter 3: Comparison of Built-in SQL Functions by Vendor.Chapter 4: SQL Procedural Extensions and User-DefinedFunctions.Chapter 5: Common ANSI SQL Functions.Chapter 6: Oracle SQL Functions.Chapter 7: IBM DB2 Universal Database (UDB) SQL Functions.Chapter 8: Microsoft SQL Server Functions.Chapter 9: Sybase ASE SQL Built-In Functions.Chapter 10: MySQL Functions.Chapter 11: PostgreSQL Functions.Chapter 12: ANSI SQL User-Defined Functions.Chapter 13: Creating User-Defined Functions in Oracle.Chapter 14: Creating User-Defined Functions with IBM DB2UDB.Chapter 15: Creating User-Defined Functions Using Microsoft SQLServer.Chapter 16: Creating User-Defined Functions in Sybase SQL.Chapter 17: Creating User-Defined Functions in MySQL.Chapter 18: Creating User-Defined Functions in PostgreSQL.Chapter 19: Reporting and Ad Hoc Queries.Chapter 20: Using Functions for Migrating Data.Chapter 21: Using Functions to Feed a Data Warehouse.Chapter 22: Embedded Functions and Advanced Uses.Chapter 23: Generating SQL with SQL and SQL Functions.Chapter 24: SQL Functions in an Application.Chapter 25: Empowering the Query with Functions and Views.Chapter 26: Understanding the Impact of SQL Functions on Queryand Database Performance.Chapter 27: Useful Queries from the System Catalog.Appendix A: Built-in Function Cross-Reference Table.Appendix B: ANSI and Vendor Keywords.Appendix C: ANSI and Vendor Data Types.Appendix D: Database Permissions by Vendor.Appendix E: ODBC and Stored Procedures and Functions.Appendix F: JDBC and Stored Procedures/Functions.Glossary.Index.