Transact-SQL Programming: Covers Microsoft SQL Server 6.5 /7.0 and Sybase Adaptive Server 11.5 [With CDROM]

by Kevin E. Kline and Andrew Zanevsky

Book Overview

Transact-SQL is a procedural language used on both Microsoft SQL Server and Sybase SQL Server systems. It is a full-featured programming language that dramatically extends the power of SQL (Structured Query Language). The language provides programmers with a broad range of features, including: A rich set of datatypes, including specialized types for identifiers, timestamps, images, and long text fields Local and global variables Fully programmable...

• Format: Paperback
• Language: English
• ISBN: 1565924010
• ISBN13: 9781565924017
• Release Date: May 1999
• Publisher: O'Reilly Media
• Length: 836 Pages
• Weight: 2.65 lbs.
• Dimensions: 1.6" x 7.0" x 9.2"

Customer Reviews

A purist's T-SQL book.

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.

Versions are Irrelevant

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.

6.5 or 7.0 - doesn't matter!

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.

If you want to know Transact, this is the book.

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.

Excellent Transact-SQL programming guide and reference

Transact-SQL Programming, by Kevin Kline, et al., is a very good SQL book, and an excellent Transact-SQL book. It covers Microsoft SQL Server 6.5/7.0 and Sybase Adaptive Server 11.5. (The changes in Transact-SQL from SQL Server 6.5 to 7.0 , by the way, are really not significant.)This book is strongly oriented towards database programming, not administration. It's not for beginners. It's not a setup and configuration guide, nor is it a "cool features" book. And it's definitely not about how to hook up Visual Basic to SQL Server and call it database programming. In order to get much from this book, the reader should be able to perform basic queries, inserts, updates and deletes using SQL. However, while some familiarity with SQL is presumed, the book has several chapters on "standard" SQL that is some of the best I've ever read for novice to intermediate SQL programming. (If you're entirely new to SQL programming get Joe Celko's Instant SQL book, or something like it.)There are a few glaring typos throughout the book. I didn't perceive them to be any more frequent than in most recent computer books. Personally, I'd rather have the information in the book available a couple of weeks earlier than to wait for another proofread to shake out a couple of dozen typos. And furthermore, if the typos, in this book at least, are really throwing you, it's because you aren't understanding the material. Go back and re-read more carefully.Once again, this is a Transact-SQL programming book. It is not a Microsoft SQL Server 7.0 book. If you don't understand the difference, you're probably not ready for this book. But if you want to learn how to use Transact-SQL to write professional, commercial database applications for either SQL Server 6.5/7.0 or Sybase Adaptive Server, this book provides everything you need to know.