Transact-SQL Cookbook and over one million other books are available for Amazon Kindle. Learn more

Vous voulez voir cette page en français ? Cliquez ici.

Sign in to turn on 1-Click ordering.
Amazon Prime Free Trial required. Sign up when you check out. Learn More
More Buying Choices
Have one to sell? Sell yours here
Start reading Transact-SQL Cookbook on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Transact-SQL Cookbook [Paperback]

Ales Spetic , Jonathan Gennick
3.1 out of 5 stars  See all reviews (12 customer reviews)
Price: CDN$ 39.99 & FREE Shipping. Details
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 1 left in stock (more on the way).
Ships from and sold by Gift-wrap available.
Want it delivered Thursday, October 23? Choose One-Day Shipping at checkout.


Amazon Price New from Used from
Kindle Edition CDN $17.24  
Paperback CDN $39.99  
Join Amazon Student in Canada

Book Description

March 29 2002 1565927567 978-1565927568 1

This unique cookbook contains a wealth of solutions to problems that SQL programmers face all the time. The 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. Authors Ales Spetic and Jonathan Gennick, two authorities with extensive database and SQL programming experience, include a discussion with each recipe to explain the logic and concepts underlying the solution.SQL (Structured Query Language) is the closest thing to a standard query language that currently exists, and Transact-SQL -- a full-featured programming language that dramatically extends the power of SQL -- is the procedural language of choice for both Microsoft SQL Server and Sybase SQL Server systems. The Transact-SQL Cookbook is designed so you can use the recipes directly, as a source of ideas, or as a way to learn a little more about SQL and what you can do with it. Topics covered include:

  • Audit logging. In addition to recipes for implementing an audit log, this chapter also includes recipes for: improving performance where large log tables are involved; supporting multiple-languages; and simulating server push.
  • Hierarchies. Recipes show you how to manipulate hierarchical data using Transact-SQL.
  • Importing data. This chapter introduces concepts like normalization and recipes useful for working with imported data tables.
  • Sets. Recipes demonstrate different operations, such as how to find common elements, summarize the data in a set, and find the element in a set that represents an extreme.
  • Statistics. This chapter?s recipes show you how to effectively use SQL for common statistical operations from means and standard deviations to weighted moving averages.
  • Temporal data. Recipes demonstrate how to construct queries against time-based data.
  • Data Structures. This chapter shows how to manipulate data structures like stacks, queues, matrices, and arrays.
With an abundance of recipes to help you get your job done more efficiently, the Transact-SQL Cookbook is sure to become an essential part of your library.

Special Offers and Product Promotions

  • Join Amazon Student in Canada

Customers Who Bought This Item Also Bought

Product Details

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

Most helpful customer reviews
3.0 out of 5 stars Good (but basic), practical text April 5 2002
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?
5.0 out of 5 stars A very practical guide to T-SQL programming! June 29 2002
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?
5.0 out of 5 stars A true book for programmers April 10 2002
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?
5.0 out of 5 stars a real life saver May 1 2002
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?
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?
1.0 out of 5 stars More beginner's book than cookbook April 13 2002
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?
Want to see more reviews on this item?
Most recent customer reviews
Search Customer Reviews
Only search this product's reviews

Look for similar items by category