- You'll save an extra 5% on Books purchased from Amazon.ca, now through July 29th. No code necessary, discount applied at checkout. Here's how (restrictions apply)
Transact-SQL Cookbook Paperback – Mar 29 2002
|New from||Used from|
Special Offers and Product Promotions
Customers Who Bought This Item Also Bought
No Kindle device required. Download one of the Free Kindle apps to start reading Kindle books on your smartphone, tablet, and computer.
Getting the download link through email is temporarily not available. Please check back later.
To get the free app, enter your mobile phone number.
From the Publisher
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.
From the Author
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
Top Customer Reviews
One or two of the chapters do cover problems which baffle a lot of experienced SQL programmers with whom I have worked; a good example is the chapter on the implementation of hierarchical data models.
There is some minimal attention paid to performance implications of alternative query formulations, but very little useful information on practical database and query tuning.
The practical examples are generally good for building the necessary context for the various implementations, but there are some clear gaps in the authors' understanding of the underlying business problems and the conceptual solution techniques. Also, there are some flat-out errors: for example, the explanation (and the implementation) of exponential averaging (more commonly referred to as smoothing) is simply incorrect.
All in all, I would recommend this to someone who is just learning SQL, and is having trouble "getting their head" around how it would be used in practice. For someone already working in the field, an online subscription to SQL Server magazine (giving access to all of the source code for the articles) would be a better investment.
Authors chose very interesting topics, and backed them up with real life scenarios and practical examples. So, every example makes sense.
Book is very easy to read and understand. If you are a beginner T-SQL programmer (or someone coming from a VB or other programming backgrounds), this book helps you get on the right track, as it clearly explains how to think in terms of sets. If you are an intermediate level SQL programmer, you can really use the examples provided in this book and start your journey towards becoming an advanced SQL programmer. For advanced users of SQL, this serves as a great reference.
I needed a clear and concise book to help me with my MS SQL programming problems. I think I found it. It clearly explains logic behind the code and examples. Other books often mix together a lot of other topics, but not this one. The text is only about coding. No administration or fine-tuning. I think it's a very good book for programmers.
If your interests include administration and other topics for DBA's, this book will be of no help for you. But that's the strength of the book. Just a few hundred pages, but no page is wasted on issues not directly related to coding.
Not for beginners and probably not for hard-core gurus. For me, a programmer with no good mentor to learn from, this book is very useful. Overall, this book has everything you need to master TSQL programming on your own.
Most recent customer reviews
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
Look for similar items by category
- Books > Computers & Technology > Databases > Database Management Systems
- Books > Computers & Technology > Microsoft > Development > SQL Server
- Books > Computers & Technology > Software > Databases
- Books > Computers & Technology > Web Development > Programming > SQL
- Books > Textbooks > Computer Science & Information Systems > Computer Science
- Books > Textbooks > Computer Science & Information Systems > Database Storage & Design
- Books > Textbooks > Computer Science & Information Systems > Programming Languages