Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your mobile phone number.

Transact-SQL Cookbook 1st Edition

3.5 out of 5 stars 15 customer reviews
ISBN-13: 978-1565927568
ISBN-10: 1565927567
Why is ISBN important?
ISBN
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Have one to sell? Sell on Amazon
Buy used On clicking this link, a new layer will be open
$15.99 On clicking this link, a new layer will be open
Buy new On clicking this link, a new layer will be open
$31.68 On clicking this link, a new layer will be open
More Buying Choices
32 New from $22.52 34 Used from $1.74
Free Two-Day Shipping for College Students with Prime Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


Windows10ForDummiesVideo
Windows 10 For Dummies Video Training
Get up to speed with Windows 10 with this video training course from For Dummies. Learn more.
$31.68 FREE Shipping. In Stock. Ships from and sold by Amazon.com. Gift-wrap available.
click to open popover

Frequently Bought Together

  • Transact-SQL Cookbook
  • +
  • SQL Cookbook (Cookbooks (O'Reilly))
Total price: $55.47
Buy the selected items together

Editorial Reviews

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.

About the Author

Ales Spetic, an independent consultant specializing in the design and implementation of financial applications, has been programming in SQL for the past six years. He has a MBA California State University, Hayward.

Jonathan Gennick is an O'Reilly & Associates editor specializing in database and programming titles. Prior to joining O'Reilly, Jonathan amassed some 17 years of programming and database management experience. During the latter part of his career he specialized in relational database programming, and more recently in database management. Jonathan got his start with relational database systems in 1990, first working with Ingres, and later with Digital's Rdb software. During that period he developed a fondness for SQL, and for the challenge of applying SQL creatively in ways that leveraged it's set-oriented capabilities. In 1994 Jonathan made the leap to Oracle, and is now often found writing about it. Recent projects include Oracle SQLLoader (O'Reilly & Associates, 2001); Oracle SQLPlus Pocket Reference (O'Reilly & Associates, 2000); Oracle SQL*Plus: The Definitive Guide (O'Reilly & Associates, 1999); More recently, Jonathan has made forays into other database products, coauthoring Transact-SQL Cookbook (O'Reilly & Associates, 2002) and editing Practical PostgreSQL (O'Reilly & Associates, 2002). Jonathan is certified as an Oracle DBA and is a member of MENSA and the Oracle Technology Network. He holds a Bachelor of Arts degree in Information and Computer Science, with a Business Administration minor, from Andrews University in Berrien Springs, Michigan. Jonathan currently resides in Munising, Michigan with his wife Donna and their two children: Jenny and Jeff. Jonathan may be contacted by email at jonathan@gennick.com, and you can learn more about him personally by visiting his website at http://gennick.com.

NO_CONTENT_IN_FEATURE

The latest book club pick from Oprah
"The Underground Railroad" by Colson Whitehead is a magnificent novel chronicling a young slave's adventures as she makes a desperate bid for freedom in the antebellum South. See more

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: 7 x 0.7 x 9.2 inches
  • Shipping Weight: 1 pounds (View shipping rates and policies)
  • Average Customer Review: 3.5 out of 5 stars  See all reviews (15 customer reviews)
  • Amazon Best Sellers Rank: #1,405,547 in Books (See Top 100 in Books)

Customer Reviews

Top 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.
Comment 22 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
By A Customer on April 10, 2002
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.
Comment 15 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
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.
Comment 6 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
The chapters in the book are laid out properly. I recommend this book to anyone who wants to further expand their knowledge. There are some errors in the book. But this is so typical of programming books. I haven't run into any problems that I couldn't figure out.
It helped me solve a problem that had been pestering me for some time. Like other O'Reilly titles, the book is an excellent piece of work.
Comment 5 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
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.
Comment 7 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
By A Customer on May 28, 2002
Format: Paperback
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.
Comment 5 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
By A Customer on June 17, 2002
Format: Paperback
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 Intervals and Exact Confidence Intervals.
Although TSQL isn't the right tool for this particular job, requirements can sometimes put you in a bind. I would like to see this chapter greatly expanded in a future edition. Someone needs to fill this vacuum.
Comment 5 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
By C. Hudson on February 12, 2006
Format: Paperback
Read the negative reveiws and bought the book anyway. Still can't figure out what it was that other reviewers found objectionable...

This book was helpful to me because it takes the subject of a SQL query much deeper than most of the texts that I have read. It puts emphasis on solving problems using the query language instead of procedural language, and it shows some truly eye-opening examples of what can be done with a simple SELECT statement.

The authors are clearly subject experts, and their work is in keeping with O'Reilly's generally high standards for technical references. My only regret is that the book wasn't longer.
Comment 2 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Recent Customer Reviews

Set up an Amazon Giveaway

Transact-SQL Cookbook
Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more about Amazon Giveaway
This item: Transact-SQL Cookbook