|Amazon Price||New from||Used from|
This cookbook contains a wealth of solutions to problems that SQL programmers face all the time. Recipes inside range from how to perform simple tasks, like importing external data, to ways of handling issues that are more complicated, like set algebra. Each recipe includes a discussion that explains the logic and concepts underlying the solution. The book covers audit logging, hierarchies, importing data, sets, statistics, temporal data, and data structures.
If you have recently learned SQL, then you know what the basic statements are all about. What you need to learn next is how to "think SQL" in order to creatively apply it to the programming problems you encounter in your daily work. This is a hard thing to "teach"; the creative application of SQL is really something you need to learn by example. That's the whole point of this book, to provide examples of SQL being used creatively, and in ways that aren't immediately obvious, to solve everyday problems. You'll be able to apply our patterns to your own work, and you'll no doubt be inspired to discover even more creative solutions of your own. This book isn't just for those who are new to SQL. Even if you're an experienced SQL programmer, you probably haven't seen it all, and we think you'll discover at least one new technique in this book.See all Product Description
Bought this without reading the reviews. Big mistake. Full of terribly simple examples and bad English. Not worth the time at all. Read morePublished on July 21 2002 by John Gibbs
This book isn't worth the paper its printed on. The code is all stuff from magazines and other books. I see a lot of code from Henderson's book here. Read morePublished on July 11 2002 by Tom Dunn
Information on performing statistics calculations using TSQL is very rare. Using this book, I was able to write a couple of User-Defined Functions that provide both Confidence... Read morePublished on June 17 2002
No DBA nonsense, just plain programming. Great stuff, clear explanations, excellent code!!! It's an incredible book that can really help programmers get up to speed quickly.Published on May 28 2002
Almost everything in this book can be found in the books on-line. This is like a printed version of them. If you need a printed version of the bol, get this book.Published on May 12 2002 by Bob Lee