Transact-SQL Cookbook and over one million other books are available for Amazon Kindle. Learn more
CDN$ 37.75
  • List Price: CDN$ 39.99
  • You Save: CDN$ 2.24 (6%)
Only 1 left in stock (more on the way).
Ships from and sold by Amazon.ca.
Gift-wrap available.
Quantity:1
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Transact-SQL Cookbook Paperback – Mar 29 2002


See all 2 formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle Edition
"Please retry"
Paperback
"Please retry"
CDN$ 37.75
CDN$ 26.45 CDN$ 26.09

2014 Books Gift Guide
Yes Please is featured in our 2014 Books Gift Guide. More gift ideas

Customers Who Bought This Item Also Bought



Product Details

  • Paperback: 304 pages
  • Publisher: O'Reilly Media; 1 edition (March 29 2002)
  • Language: English
  • ISBN-10: 1565927567
  • ISBN-13: 978-1565927568
  • Product Dimensions: 17.8 x 1.7 x 23.3 cm
  • Shipping Weight: 454 g
  • Average Customer Review: 3.1 out of 5 stars  See all reviews (12 customer reviews)
  • Amazon Bestsellers Rank: #952,989 in Books (See Top 100 in Books)
  • See Complete Table of Contents

Product Description

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.

Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Customer Reviews

3.1 out of 5 stars
Share your thoughts with other customers

Most helpful customer reviews

Format: Paperback
Rather than a real-world "cookbook", ostensibly targeted to database professionals who want to avoid reinventing the wheel, this book would be better positioned as a companion to an introductory text on SQL (e.g. for a class on SQL, where the class laboratory work employs SQL Server).
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.
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again.
Format: Paperback
This is a very concise and to-the-point book. It assumes that the user has a basic understanding of T-SQL. So, you won't see any repetition from SQL Server Books Online.
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.
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again.
Format: Paperback
This book is everything I was looking for. I bought it on my recent trip to United States. I had a chance to read it on the long flight back to Europe.
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.
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again.
By Morgan Lee on May 1 2002
Format: Paperback
I've read this book and I'm recommending it to all my friends. This book contains concise explanations of many important topics. Anyone who would like to learn about the concepts should read it since it covers almost all levels of understanding from the overall picture to the nitty-gritty details of Transact-SQL. Examples are clear and well structured.

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.
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again.
Format: Paperback
I wish I hadn't wasted my money on this. I recognize much of this 'cookbook' code from Ken Henderson's Guru's Guide to Transact-SQL book. That book is well-written and full of innovative code. This one isn't. This one is filled with horrid English and gradeschool grammar errors and code that looks like it came from somewhere else. There's little or no explanation for much of the code. What explanations there are are frequently wrong. I will be returning this for a refund.
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again.
Format: Paperback
When they called this a cookbook, I was expecting lots of advanced sample code, especially given that the book comes from O'Reilly. I could not be more disappointed. The examples (the few that there are in such a thin, 302 page book) are really on the level of the Books Online. There aren't a lot of gourmet dishes in this one. Recommend you pass on it and get something like Henderson's two Guru's Guide books instead. Now _those_ are cookbooks!
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again.


Feedback