SQL Functions Programmer's Reference (Programmer to Programmer)

Gives programmers two-in-one coverage, with both a "how-to" on SQL functions and a complete SQL functions reference SQL is the standard language for database queries; this book's advanced coverage helps programmers write their own SQL functions Covers both the internationally standardized SQL 99 functions and the hundreds of additional functions introduced by vendors, including the subtle variations required to successfully migrate or interoperate between vendor products Covers the latest versions of the major relational database management system (RDMS) applications: Microsoft SQL Server, Oracle, IBM DB2, and MySQL SQL functions are special commands for manipulating data. The international SQL standard defines many functions implemented by all major RDBMS vendors. This comprehensive SQL functions reference enables you to quickly master SQL function data manipulation in any database.First, the book presents the basics you need to use standard SQL functions with any database. Then the expert authors take you into the core reference material for built-in and user-defined SQL functions in each major RDBMS product. Packed with examples, you'll immediately learn to apply standard functions and extend your power with functions you define.You'll learn all of this from a core author team from Perpetual Technologies, Inc. These experts have extensive experience with Oracle, SQL Server, Sybase, DB2, and MySQL, database design and management for some of the world's largest corporations and government agencies.This book is for the SQL programmer or software developer of any level who needs to effectively retrieve data from a relational database or integrate applications with RDBMS implementations. This is a reference guide to Structured Query Language (SQL) functions, which play a critical role in the retrieval and display of data. The guide covers a range of SQL implementations and cross- referencing between implementations.