 SQL Functions Programmer's Reference
ISBN: 978-0-7645-6901-2
Paperback
790 pages
April 2005
US $39.99
 Add to Cart
This price is valid for United States. Change location to view local pricing and availability. Other Available Formats: Adobe E-Book
|
Instructors may request an evaluation copy for this title.
|
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-Defined Functions.
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 DB2 UDB.
Chapter 15: Creating User-Defined Functions Using Microsoft SQL Server.
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 Query and 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.
