Sql Functions Programmer's Reference

0.0

The book covers SQL standard functions as mandated by SQL92/99 standards - the current up-to-date international SQL standard. It also covers RDBMS (relational database management system - such as SQL Server, Oracle, etc) vendor-specific implementations' built-in SQL functions, as well as user-defined functions built with proprietary procedural extensions and/or Java, C, Python, VBScript (SQL Server 2000 DTS packages) and upcoming .NET family of languages. Special attention is given to migration issues from one RDBMS to another. In addition to describing syntax and usage of the built-in functions, the book will provide an equivalency cross-reference across different RDBMS packages. For those whose needs go beyond the built-in functionality, the book introduces and details creating custom functions using vendors’ supplied procedural extensions, as well as using general programming languages. Special Feature Wrox! Provides two-in-one coverage of SQL functions for SQL programmers with both a SQL functions "how to" and a complete SQL functions reference Focuses on the internationally standardized SQL 99 functions as well as how they are implemented in various vendor-specific product Specific coverage for those translating or moving from one product to another Advanced coverage for writing your own SQL functions Written by two hands-on experienced SQL programmers who have daily interaction with SQL functions

0.0

Alex Kriegel is a professional Database Systems Analyst with a major manufacturing firm in Oregon. He has more than 10 years of database experience including SQL Server 6.5/7.0/2000 and Oracle (versions 8/8i) both as developer and DBA. Alex has B.Sc. in Solid State Physics from State Polytechnic Institute of Minsk, Belarus. He is the author of SQL Bible. Victor Schulman is the CTO and owner of Canadian Data Timers Inc. He has over 15 years programming experience in applications and systems including more than 8 years relational database development experience. Victor is a graduate of the Moscow Teacher's University of Mathematics, the Moscow Medical Institute, and the Herzing Institute (Winnipeg) of Computer Programming. Table of Contents Acknowledgments Introduction Exploring Popular SQL Implementations Functions: Concept and Architecture Comparison of Built-in SQL Functions by Vendor SQL Procedural Extensions and User-Defined Functions Common ANSI SQL Functions Oracle SQL Functions IBM DB2 Universal Database (UDB) SQL Functions Microsoft SQL Server Functions Sybase ASE SQL Built-In Functions MySQL Functions PostgreSQL Functions ANSI SQL User-Defined Functions Creating User-Defined Functions in Oracle Creating User-Defined Functions with IBM DB2 UDB Creating User-Defined Functions Using Microsoft SQL Server Creating User-Defined Functions in Sybase SQL Creating User-Defined Functions in MySQL Creating User-Defined Functions in PostgreSQL Reporting and Ad Hoc Queries Using Functions for Migrating Data Using Functions to Feed a Data Warehouse Embedded Functions and Advanced Uses Generating SQL with SQL and SQL Functions SQL Functions in an Application Empowering the Query with Functions and Views Understanding the Impact of SQL Functions on Query and Database Performance 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