Sql Functions Programmer's Reference

E-Book Overview

• 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

E-Book Information

• Series: Programmer to Programmer

• Year: 2,005

• Edition: 1

• City: Indianapolis, IN

• Pages: 793

• Pages In File: 793

• Language: English

• Topic: 76

• Identifier: 9780764569012,0764569015

• Ddc: 005.13/3

• Lcc: QA76.73.S67 S674 2005

• Org File Size: 9,803,170

• Extension: pdf

• Toc: Cover......Page 1 Contents......Page 13 Introduction......Page 37 Introduction to SQL......Page 43 Overview of Vendor Implementations of SQL......Page 44 MySQL......Page 45 Connecting to SQL Databases......Page 46 Creating SQL Databases......Page 47 Querying SQL Databases......Page 49 Manipulating Data in SQL Databases......Page 51 Summary......Page 53 What Is a Function?......Page 55 Simple UNIX Shell Function Example......Page 56 ANSI SQL Functions......Page 57 Built-in Functions......Page 58 Practical Uses of Functions......Page 59 a SQL Function......Page 60 or by Reference......Page 64 Scope of a Function......Page 66 Overloading......Page 67 and Non-Deterministic Functions......Page 69 IBM DB2 UDB......Page 71 Microsoft SQL Server......Page 72 MySQL and PostgreSQL......Page 73 Summary......Page 74 Types of Functions......Page 75 Classifying Built-in SQL Functions......Page 76 Oracle......Page 77 IBM DB2 UDB......Page 78 Microsoft SQL Server and Sybase ASE......Page 79 PostgreSQL......Page 81 Overview of Built-in Functions by Vendor......Page 82 Summary......Page 90 Procedural versus Declarative Languages......Page 91 Extensions to SQL......Page 93 Oracle PL/SQL......Page 94 Microsoft or Sybase Transact-SQL......Page 96 IBM Procedural SQL......Page 97 PostgreSQL......Page 99 Summary......Page 100 Common ANSI SQL Functions......Page 101 Aggregate Functions......Page 102 AVG()......Page 104 COUNT()......Page 105 MAX() and MIN()......Page 106 String Functions......Page 107 ASCII()......Page 108 CONCAT()......Page 109 LENGTH() or LEN()......Page 110 Mathematical Functions......Page 111 ABS()......Page 114 ASIN()......Page 115 CEIL() or CEILING() and FLOOR()......Page 116 COT()......Page 117 EXP()......Page 118 MOD()......Page 119 POWER()......Page 121 ROUND()......Page 122 SIGN()......Page 123 SQUARE()......Page 124 TANH()......Page 125 TRUNC() or TRUNCATE()......Page 126<