Programming Books C Java PHP Python Learn more Browse Programming Books
Buy Used
$5.16
FREE Shipping on orders over $35.
Condition: Used: Good
Comment: This item has been gently used.
Add to Cart
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more

Transact-SQL Programming: Covers Microsoft SQL Server 6.5 /7.0 and Sybase Adaptive Server 11.5 Paperback


Amazon Price New from Used from Collectible from
Paperback
"Please retry"
$32.49 $0.01

NO_CONTENT_IN_FEATURE

Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Product Details

  • Paperback: 840 pages
  • Publisher: O'Reilly Media; First edition (April 8, 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 (102 customer reviews)
  • Amazon Best Sellers Rank: #1,480,851 in Books (See Top 100 in Books)

Editorial Reviews

About the Author

Kevin Kline is the Technical Strategy Manager for SQL Server Solutions at Quest Software, a leading provider of award winning tools for database management and application monitoring tools. Kevin is also a founding board member and former President of the international Professional Association for SQL Server (PASS) and frequently contributes to database technology magazines, web sites, and discussion forums. Kevin's most popular book is SQL in a Nutshell published by O'Reilly Media. Kevin is also the author of monthly magazine columns for SQL Server Magazine and Database Trends & Applications. Kevin is a top rated speaker, appearing at international conferences like Microsoft TechEd, DevTeach, PASS, Microsoft IT Forum, and SQL Connections.

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 lee_k_gould@yahoo.com.

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 zanevsky@azdatabases.com.


More About the Authors

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

A perfunctory appendix on 7.0 does not constitute SQL Server 7.0 coverage.
Jim Burns
My first problem with this book is that it misleads you into believing its a 7.0 book when in fact it's not even specifically an MS SQL book -- it also covers Sybase.
Dave Simon
Also, the book seemed uneven -- I guess that's probably due to the multiple authors, but I dunno.
Ron Estridge

Most Helpful Customer Reviews

17 of 17 people found the following review helpful By Kevin Tsai on February 29, 2000
Format: Paperback
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.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
9 of 9 people found the following review helpful By Morris on October 19, 1999
Format: Paperback
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
12 of 13 people found the following review helpful By A Customer on March 23, 2000
Format: Paperback
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
8 of 8 people found the following review helpful By boneheadIII (boneheadiii@media-net.net) on October 15, 1999
Format: Paperback
There aren't a lot of Transact-SQL books on the market, and when I saw that O'Reilly had one I had to have it. Whether you use SQL every day or just want to start learning... This is the perfect book. From the basics, to an in-depth understanding of the subject, this book acomplishes it all. Transact-SQL in a Nutshell is by far, the best 35 bucks I've ever spent. I use SQL every day, and this book has improved my developement time and quality by leaps and bounds. This one should actually get an extra star.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
11 of 12 people found the following review helpful By Jim Burns on April 25, 2000
Format: Paperback
I remember SQL Server 4.2 and 6.5 well enough to know that this was a good book in its time. Problem is, 7.0 has been out for over a year and SQL 2000 is on the horizon. This book is woefully out of date. It queries system tables (in the first place, you shouldn't do that unless absolutely necessary) that don't even exist anymore (e.g., sysprocedures). It uses old-style joins throughout, despite the fact that they've been deprecated by Microsoft, Soukup&Delaney, Henderson, and many others. Last but not least, it *claims* 7.0 coverage, but does not deliver. A perfunctory appendix on 7.0 does not constitute SQL Server 7.0 coverage.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
11 of 12 people found the following review helpful By Anthony Witecki on November 26, 1999
Format: Paperback Verified Purchase
This is an outstanding book on writing Transact SQL. The changes brought by SQL Server 7.0 have little impact on the value this book provides to programmers that are new to T-SQL. The book is focused on writing better code, database design, and optimization. If you are looking for a book on SQL Server, this is not for you. If you are looking for an introductory level book, this book is not for you.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
9 of 10 people found the following review helpful By A Customer on March 31, 2000
Format: Paperback
I bought this book because the cover said it covered SQL Server7.0. Really, it's just a 6.5 book with a single appendix on 7.0. Somany things changed in 7.0 that this makes the book virtually useless for 7.0 users. Basically, you pay money for one chapter and that chapter isn't really that good.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
6 of 6 people found the following review helpful By Brook on November 29, 2000
Format: Paperback
I'm a developer with some SQL experience who was new to Sybase ASE when I picked up this book. I found it very helpful and well written. I refer to this book every day, and it hass improved my programming skills.
This was the only book I could find that covered T-SQL for Sybase at all. Without it, I would have a hard time doing my job. However, I have found a few inaccuracies and code that will not work (check out ANSI-style joins and DEFAULT inside a CREATE TABLE to see what I mean). This is why this otherwise excellent book only rates 4 stars.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Most Recent Customer Reviews

Search
ARRAY(0xa702a384)

What Other Items Do Customers Buy After Viewing This Item?