By Ales Spetic, Jonathan Gennick
First Edition
March 2002
Pages: 302
Series: Cookbooks
ISBN 10: 1-56592-756-7 |
ISBN 13: 9781565927568
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.
Full Description
- 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.
Cover | Table of Contents | Colophon
Featured customer reviews
Be the first person to review this book!
Media reviews
"This is the first 'book review' on my site and it happens to be the most practical Transact-SQL (T-SQL) book I've ever read. I read this book cover to cover and picked up a lot of tips and tricks. Before I start with the 'chapter by chapter' review, let me walk you through the key characteristics of this book. It is a concise (Hardly 300 pages), practical, no-nonsense book...Overall, this is a valuable book for beginning-to-intermediate SQL Server programmers and a great reference for experienced database professionals."
--Narayana Vyas Kondreddi, SQL Server website, August 2002
"The 'Transact-SQL Cookbook' is the best book I have read for learning how to get T-SQL to do a lot of things you never knew it could. Did you know you can perform matrix multiplication in SQL? How do you create a calendar in SQL? How do you find non-recurring events? What about using T-SQL to calculate statistical autocorrelation? Yes, all of these things are possible to do in T-SQL, in fact, they're discussed in detail in this book...During development, if a particularly hairy T-SQL task comes your way, chances are, the solution is covered in some form or another in this book. I would highly recommend this book to anyone who regularly works with or writes T-SQL. A must have for any library."
--Salt Lake City ColdFusion User Group, July 2002
"A well-presented text that should have something of interest for any SQL user."
--Major Keary, Book News 2002 No 10
