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 Tuesday, July 29? Choose One-Day Shipping at checkout.


Amazon Price New from Used from
Kindle Edition CDN $16.52  
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.

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
1.0 out of 5 stars A bad book July 21 2002
Bought this without reading the reviews. Big mistake. Full of terribly simple examples and bad English. Not worth the time at all. Don't know where they get some of these authors.
Was this review helpful to you?
1.0 out of 5 stars Terrible, just terrible July 11 2002
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. The writing is also terrible - no explanations whatsoever. Suggest spending your money on something else-just about anything, in fact.
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?
4.0 out of 5 stars Good Reference June 17 2002
By A Customer
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.
Was this review helpful to you?
5.0 out of 5 stars Best Buy! May 28 2002
By A Customer
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.
Was this review helpful to you?
1.0 out of 5 stars Terrible waste of money May 12 2002
By Bob Lee
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.
Was this review helpful to you?
Want to see more reviews on this item?
Most recent customer reviews
5.0 out of 5 stars a real life saver
I've read this book and I'm recommending it to all my friends. This book contains concise explanations of many important topics. Read more
Published on May 1 2002 by Morgan Lee
1.0 out of 5 stars More beginner's book than cookbook
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. Read more
Published on April 13 2002 by Barb Tabor
5.0 out of 5 stars A true book for programmers
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. Read more
Published on April 10 2002 by "hans_waldde"
5.0 out of 5 stars This book is great!
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. Read more
Published on April 10 2002 by Austin McMillan
1.0 out of 5 stars Borrows heavily from Henderson's Guru's Guide to T-SQL
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. Read more
Published on April 5 2002 by Bill Carlos
3.0 out of 5 stars Good (but basic), practical text
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... Read more
Published on April 5 2002 by Nicholas Bennett
Search Customer Reviews
Only search this product's reviews

Look for similar items by category