Books

SQL Functions Programmer's Reference (Programmer to Programmer)

Average customer rating:

Test review
for the most part it does deliver

SQL Functions Programmer's Reference (Programmer to Programmer)
Arie Jones , Ryan K. Stephens , Ronald R. Plew , Robert F. Garrett , and Alex Kriegel
Manufacturer: Wrox
ProductGroup: Book
Binding: Paperback

Database Management Systems | Databases | Computers & Internet | Subjects | Books

General | Computers & Internet | Subjects | Books

General | Software | Computers & Internet | Subjects | Books

Look Inside Computer Books | Trip | Specialty Stores | Books

All Amazon Upgrade | Amazon Upgrade | Stores | Books

Computers & Internet | Amazon Upgrade | Stores | Books

General | Software Books | Custom Stores | Stores | Software
Similar Items:

Beginning SQL (Programmer to Programmer)
Beginning Database Design (Wrox Beginning Guides)
SQL: The Complete Reference, Second Edition
Beginning Transact-SQL With SQL Server 2000 and 2005
SQL Bible

ASIN: 0764569015

Book 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

Download 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

Customer Reviews:

Test review.......2005-09-30

More a book for consultants as looks at functions across differnet platforms. Bur clear coding examples. Would re-purchase for the right price.

for the most part it does deliver.......2005-08-24

Like with every Wrox book there are many voices in the book. Unfortunately they do not comprise a choir...You will find a useful info scattered throughout the book; do not try to get a coherent picture out of it. I liked the idea of the book, and for the most part it does deliver.
There were small annoyances here and there:
For example, I find it strange that authors thought it necessary to give their version of pronunciation ":(otherwise known as SQL and pronounced "SEE-kwul") " for what is clearly not a beginner book; and I pronounce it "ess-que-ell" as many of my colleagues do)

Same goes for the first few chapters where authors have chosen to show examples of a basic queries, connect to database syntax etc. UNIX shell function example (p.14) was rather a dubious choice - why not C? VB? Java? Perl? Most database application developers are not familiar with the shell scripts, and could not care less.

It really would help me if the book covered creation of the user defined functions with Java and .NET (available in Oracle, DB2 UDB, PostgreSQL (Java), MSSQL Server, IBM DB2 UDB (.Net/C#); the book only covers Sybase where function created in Java 1.1... Reporting issues (chapter 19) seem torn out of some other book, and badly fitted into SQL Functions...The subject of Regular Expressions was hardly paid any attention, save for the fact that such thing does exist; MSSQL Server, for instance, provides access to OLE interface of its scripting engine Regex implementation. On the other hand, I was delighted to see PostgreSQL included.

Average customer rating:

Sql Functions Programmers Reference
Alex Kriegel
Manufacturer: HUNGRY MINDS IDG
ProductGroup: Book
Binding: Paperback

Books:

Books