SQL Functions Programmer's Reference

Arie Jones, Ryan K. Stephens, Ronald R. Plew, Robert F. Garrett, Alex Kriegel

SQL Functions Programmer's Reference
  • 出版商: Wrox Press
  • 出版日期: 2005-04-29
  • 售價: $1,590
  • 貴賓價: 9.5 折 $1,511
  • 語言: 英文
  • 頁數: 790
  • 裝訂: Paperback
  • ISBN: 0764569015
  • ISBN-13: 9780764569012
  • 相關分類: SQL

    • 已過版

買這商品的人也買了...

相關主題

商品描述

Description:

  • 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

 

Table of Contents:

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-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.

類似商品