SQL functions programmer’s reference
* 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 st...
Uložené v:
| Hlavní autori: | , , , , |
|---|---|
| Médium: | E-kniha |
| Jazyk: | English |
| Vydavateľské údaje: |
Newark
Wiley
2005
John Wiley & Sons, Incorporated Wrox Wiley Pub |
| Vydanie: | 1st ed. |
| Edícia: | Computer program language |
| Predmet: | |
| ISBN: | 0764569015, 9780764598074, 0764598074, 9780764569012 |
| On-line prístup: | Získať plný text |
| Tagy: |
Pridať tag
Žiadne tagy, Buďte prvý, kto otaguje tento záznam!
|
Obsah:
- Finding Information about UDFs in the Database -- Restriction on UDFs -- Summary -- Chapter 15: Creating User-Defined Functions Using Microsoft SQL Server -- Acquiring Permissions -- Creating UDFs -- Altering UDFs -- Dropping UDFs -- Debugging Transact-SQL UDFs -- Error Handling in Transact-SQL UDFs -- Using Transact-SQL UDFs in Transactions -- Finding Information about UDFs -- Restrictions on Transact-SQL UDFs -- Summary -- Chapter 16: Creating User-Defined Functions in Sybase SQL -- Acquiring Privileges -- Creating UDFs -- Mapping Java and SQL Data Types -- Altering UDFs -- Dropping UDFs -- Debugging UDFs -- Error Handling in UDFs -- Finding Information about UDFs -- Summary -- Chapter 17: Creating User-Defined Functions in MySQL -- Acquiring Permissions -- Creating UDFs -- Creating External Functions -- Altering UDFs -- Dropping UDFs -- Error Handling and Debugging -- Finding Information about UDFs -- Summary -- Chapter 18: Creating User-Defined Functions in PostgreSQL -- Acquiring Permissions -- Query SQL Functions -- Dropping UDFs -- Debugging PostgreSQL UDFs -- Error Handling -- Overloading UDFs -- Finding Information about UDFs -- Restrictions on Calling UDFs from SQL -- Summary -- Chapter 19: Reporting and Ad Hoc Queries -- Identifying Your Reporting Needs -- Creating Standardized Reports -- Processing Ad Hoc Query Requests -- Effectively Delivering Data to the Requestor -- Summary -- Chapter 20: Using Functions for Migrating Data -- Understanding Migration of Data -- Understanding the Data Migration Process -- SQL Function's Role in Data Migration -- Summary -- Chapter 21: Using Functions to Feed a Data Warehouse -- Architecture of a Data Warehouse -- SQL Function's Role in Data Warehouse Processing -- Feeding and Using the Data Warehouse -- Summary -- Chapter 22: Embedded Functions and Advanced Uses -- ESQL Statements
- SQL Functions Programmer's Reference SQL Functions Programmer's Reference SQL Functions Programmer's Reference -- Chapter 1: Exploring Popular SQL Implementations -- Introduction to SQL -- Understanding the SQL Standard -- Overview of Vendor Implementations of SQL -- Connecting to SQL Databases -- ANSI SQL Data Types -- Creating SQL Databases -- Querying SQL Databases -- Manipulating Data in SQL Databases -- Summary -- Chapter 2: Functions: Concept and Architecture -- What Is a Function? -- ANSI SQL Functions -- Built-in Functions -- Creating, Compiling, and Executing a SQL Function -- Passing Parameters by Value or by Reference -- Scope of a Function -- Classifying SQL Functions: Deterministic and Non-Deterministic Functions -- Summary -- Chapter 3: Comparison of Built-in SQL Functions by Vendor -- Types of Functions -- Classifying Built-in SQL Functions -- Overview of Built-in Functions by Vendor -- Summary -- Chapter 4: SQL Procedural Extensions and User-Defined Functions -- Procedural versus Declarative Languages -- ANSI SQL Guidance for Procedural Extensions to SQL -- SQL Procedural Extensions by Vendor -- Summary -- Chapter 5: Common ANSI SQL Functions -- ANSI Query Syntax -- Aggregate Functions -- String Functions -- Mathematical Functions -- Miscellaneous Functions -- Summary -- Chapter 6: Oracle SQL Functions -- Oracle Query Syntax -- Aggregate Functions -- Analytic Functions -- Character Functions -- Regular Expressions -- Conversion Functions -- Date and Time Functions -- Numeric Functions -- Object Reference Functions -- Miscellaneous Single-Row Functions -- Summary -- Chapter 7: IBM DB2 Universal Database ( UDB) SQL Functions -- DB2 UDB Query Syntax -- String Functions -- Date and Time Functions -- Conversion Functions -- Security Functions -- IBM DB2 UDB Special Registers -- Miscellaneous Functions -- Summary
- Static versus Dynamic Querying -- Common Uses of Embedded Functions -- Summary -- Chapter 23: Generating SQL with SQL and SQL Functions -- Using Literal Values, Column Values, and Concatenation -- Other Functions Commonly Used to Generate SQL Code -- Summary -- Chapter 24: SQL Functions in an Application -- Calling Functions from an Application -- Sample User Login Application Using VB. Net and SQL Server -- Sample User Login Application Using Java and Oracle -- Sample User Login Application Using ASP. NET -- Summary -- Chapter 25: Empowering the Query with Functions and Views -- Understanding How Views Empower Queries -- Understanding the Role of SQL Functions in Views -- Summary -- Chapter 26: Understanding the Impact of SQL Functions on Query and Database Performance -- Prioritizing Transaction and Query Performance -- Understanding the Adverse Effects of Function Performance -- Examining the Impact of SQL Functions in SQL Statements -- Comparing Built-in Functions and User-Defined Functions -- Creating a Balance between Security and Performance -- Summary -- Chapter 27: Useful Queries from the System Catalog -- Useful System Catalog Queries for the Programmer -- Oracle -- IBM DB2 -- PostgreSQL -- Microsoft SQL Server -- Sybase -- MySQL -- Summary -- Appendix A: Built-in Function Cross-Reference Table -- Appendix B: ANSI and Vendor Keywords -- ANSI SQL Keywords -- Oracle Keywords -- DB2 Reserved Words and Keywords -- SQL Server Reserved Words -- MySQL Reserved Words and Keywords -- Sybase Reserved Words and Keywords -- PostgreSQL Reserved Words and Keywords -- Appendix C: ANSI and Vendor Data Types -- ANSI SQL Data Types -- Oracle 9i Data Types -- Oracle 10g Data Types -- IBM DB2 Data Types -- SQL Server Data Types -- Sybase Data Types -- MySQL Data Types -- PostgreSQL Data Types -- Appendix D: Database Permissions by Vendor
- Oracle 9i Privileges -- Oracle 9i Object Privileges -- Oracle 10g Privileges -- Oracle 10g Object Privileges -- IBM DB2 Database Privileges -- IBM DB2 Privileges -- IBM DB2 Object Privileges -- SQL Server Permissions -- Sybase Permissions -- MySQL Privileges -- PostgreSQL Privileges -- PostgreSQL Object Privileges -- Appendix E: ODBC and Stored Procedures and Functions -- Appendix F: JDBC and Stored Procedures/Functions -- Glossary -- Index
- Chapter 8: Microsoft SQL Server Functions -- SQL Server Query Syntax -- String Functions -- Date and Time Functions -- Metadata Functions -- Configuration Functions -- Security Functions -- System Functions -- System Statistical Functions -- Undocumented Functions -- Summary -- Chapter 9: Sybase ASE SQL Built-In Functions -- Sybase Query Syntax -- String Functions -- Date and Time Functions -- Conversion Functions -- Security Functions -- Aggregate Functions -- Mathematical Functions -- Text and Image Functions -- System Functions -- Unary System Functions -- Summary -- Chapter 10: MySQL Functions -- MySQL Query Syntax -- Aggregate Functions -- Numeric Functions -- String Functions -- Date-Time Functions -- Miscellaneous Functions -- Summary -- Chapter 11: PostgreSQL Functions -- PostgreSQL Query Syntax -- Aggregate Functions -- String Functions -- Mathematical Functions -- Date-Time Functions -- Geometric Functions -- Miscellaneous Functions -- Summary -- Chapter 12: ANSI SQL User-Defined Functions -- User-Defined Functions or SQL Routines? -- Creating UDFs -- Altering UDFs -- Removing UDFs -- Summary -- Chapter 13: Creating User-Defined Functions in Oracle -- PL/SQL Compiler -- Oracle 10g Compiler Optimization -- Acquiring Permissions -- Creating UDFs -- Altering UDFs -- Dropping UDFs -- Debugging PL/SQL Functions -- Error Handling in PL/SQL Functions -- Adding PL/SQL Functions to an Oracle Package -- Overloading -- Using PL/SQL UDF in Transactions -- Compiling PL/SQL Modules into Machine Code -- Finding Information about UDFs in the RDBMS -- Restrictions on Calling PL/SQL UDFs from SQL -- Summary -- Chapter 14: Creating User-Defined Functions with IBM DB2 UDB -- Acquiring Permissions -- Creating UDFs -- Altering UDFs -- Dropping UDFs -- Debugging UDFs -- Overloading -- Using SQL PL UDF in Transactions