Transact-SQL Programming (Paperback)

by Lee Gould (Author), Andrew Zanevsky (Author), Kevin Kline (Author)

Editorial Reviews

Product Description
This definitive guide thoroughly explores all aspects of Transact-SQL, a full-featured procedural language used on both Microsoft SQL Server and Sybase SQL Server systems that dramatically extends the power of SQL (Structured Query Language). Full of examples, best practices, and real-world advice, it contains up-to-the-minute information on the latest versions: Microsoft SQL Server versions 6.5 and 7.0 and Sybase version 11.5. The book is divided into six convenient parts. Part I contains an introduction, an SQL primer, and chapters on language fundamentals, format, and style. Part II describes datatypes and variables, conditional processing, cursors, error handling, temporary objects, transactions, and locking. Part III covers the various types of functions available to programmers and CASE extensions to the language. Part IV discusses stored procedures and modular design, triggers, views, extended stored procedures, and BCP. Part V describes code design and maintenance, optimization, tuning, transactions, locking, testing, and debugging. The appendixes summarize system tables and version differences. The enclosed CD-ROM contains an extensive set of examples from the book and complete programs that illustrate the power of the language.

About the Author
Lee Gould is a principal consultant with Sybase Professional Services in New York where she works mainly in the financial services industry on Wall Street. She has been working with SQL Server since 1992 and has been involved in the computer industry for over ten years. She has published numerous articles in Microsoft SQL Server Professional (Pinnacle Publishing) and presented on a variety of topics at the International Sybase User Group and Powersoft conferences. Lee was born in Liverpool, England. She grew up in Johannesburg, South Africa, where she attended the University of Witwatersrand and received her bachelors of commerce in business information systems. Lee immigrated to America four years ago and is currently pursuing an MBA at Seton Hall University in New Jersey. Lee lives in the suburb of North Brunswick, New Jersey, with her two cats, Lady and Paganini. She can often be seen running, cycling, swimming, and horseriding while she trains for marathons and ultra triathlon events. When not immersed in sport, Lee is an avid fan of classical music, good wine, the piano, science fiction and Terminator II. Her motto on life is "carpe diem," which she endeavors to follow regardless of where it leads her. Lee can be contacted at [e-mail].

Andrew Zanevsky, an independent consultant and founder and president of AZ Databases, Inc., has been working with SQL Server since 1992. He writes a monthly column "Super Administrator," for Microsoft SQL Server Professional (Pinnacle Publishing) and has published more than a hundred technical articles throughout his career. He immigrated to the United States from Minsk, Belarus in 1991. He started programming in 1982 and holds a degree from the Belarus State University of Informatics and Radioelectronics (equivalent to an M.S. in computer science). Andrew lives in a suburb of Chicago with his wife Katrin, son Anthony, and stepdaughter Esther. Katrin is also a SQL Server consultant. They work on some projects together and can talk about Transact-SQL at dinner. Andrew's daughter Nikkie lives in New York, wants to be a writer, and has won numerous awards in art contests. Andrew was the president of the Great Lakes SQL Server Users Group in Chicago from 1994 through 1997. He can be reached at [e-mail].

Product Details

• Paperback: 836 pages
• Publisher: O'Reilly Media, Inc. (April 1, 1999)
• Language: English
• ISBN-10: 1565924010
• ISBN-13: 978-1565924017
• Product Dimensions: 9.2 x 7 x 1.6 inches
• Shipping Weight: 2.6 pounds
• Average Customer Review: 2.7 out of 5 stars See all reviews (101 customer reviews)
• Amazon.com Sales Rank: #297,510 in Books (See Bestsellers in Books)

  Popular in this category: (What's this?)

  #90 in

  Books > Computers & Internet > Databases > Relational Databases

Customer Reviews

Most Helpful Customer Reviews

17 of 17 people found the following review helpful:

5.0 out of 5 stars A purist's T-SQL book., February 29, 2000

By	Kevin Tsai "kekezinho" (Oakland, CA United States) - See all my reviews (REAL NAME)

You'd think this book covers SQL Server 6.5, 7.0 and Sybase SQL Server that this is going to be patchy here and there, trying to cover one product here and another product there. You'd think SQL Server 7.0 is so much more advanced than SQL Server 6.5 that this book has to make so many compromises that it's only half good for either. And you'd probably think that this book has so few pages, this must only be an intro.

Not so on all three accounts. This book is to-the-point Transact-SQL. There's no filler material here. I've programmed in Transact-SQL for quite awhile, and the examples, along with the descriptions, help me produce clean code. SQL Server is sensitive to how code and indexes interact. The author stresses the synergistic design of indexes and code.

Here is what you do have to watch out for if you're considering this book:

*This book is clearly a T-SQL only book. For example, it does not dwell on the exact page size; 6.5 uses 2k pages, while 7.0 uses 8k pages. You must be aware of this when you code and design indexes. This book covers the concepts very well, but it is up to you to apply the concepts to your design.

*Certain exciting additions such as Linked Servers are not discussed. The book is a bit backwards on the inter-operability of SQL Server, since Linked Server offers remote queries in addition to the functionality of Remote Servers (Linked Server is not available in 6.5).

*Replication is also not discussed. SQL Server 7.0 has greatly improved on the replication capabilities over 6.5, both in ease and reliability. In all fairness, replication is an enterprise architecture issue more than a coding issue.

Like all thick products, SQL Server (and Sybase SQL Server) deserves more than one book on any developer's/DBA's desk. I really like this book as a coding guide, but would definitely supplement this with:

*Inside SQL Server 7.0: performance tuning and deep understanding of SQL Server under-the-hood. This book is hard core.

*Books Online: excellent coverage on Replication, DTC, disaster recovery. Although not nice to read, I've had a hard time finding this information elsewhere.

*Deploying SQL Server: high level deployment guide.

9 of 9 people found the following review helpful:

5.0 out of 5 stars 6.5 or 7.0 - doesn't matter!, October 19, 1999

By	Morris (Nashville, Tennessee) - See all my reviews

T-SQL hasn't changed so much in 7.0 that its users cannot get a lot of useful information out of this book. For 6.5 DBA's, it is a *MUST* have book, no matter what your skill level.

Don't let the people who whine about it being focussed more on 6.5 than 7.0 scare you away. These people are obviously not managing real database installations because most of the professional DBA's I know (me included) are still managing 6.5 servers and will be throughout most of next year.

Buy this book if you want to be a DBA worth your paycheck.

12 of 13 people found the following review helpful:

2.0 out of 5 stars Good, but very specific to 6.5, March 23, 2000

By A Customer

I liked this book, but SQL 7.0 is covered in an appendix. Moreover, many of the techniques shown are archaic and have been deprecated by Microsoft, even for SQL 6.5. For example, joins are often show using the old join syntax. I wouldn't have such a problem with this if this book didn't advertise itself as a SQL 7.0 book. It's definitely not a 7.0 book and if you buy it expecting that, you'll be disappointed. Another problem with the book is its failure to adequately distinguish between Sybase and Microsoft syntax. There are some important differences, as the products have diverged more with each new release. Some of the examples show code that works on Sybase, but not on Microsoft (or vice versa), without telling the reader. The book would have been better off focusing on one or the other.