 |
Beginning Transact-SQL with SQL Server 2000 and 2005 View Larger Image | Paul Turley, Dan Wood
Wrox Press, Paperback, Published October 2005, 650 pages, ISBN 076457955X | List Price: $39.99
Our Price: $24.95
You Save: $15.04 (38% Off)
| | | Availability: Out-Of-Stock |
Customer Reviews: 2 Average Customer Rating:   Write a Review and tell the world about this title! People who purchase this book frequently purchase: Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
* Transact-SQL, the Microsoft implementation of the industry-standard SQL, includes
many proprietary features that Microsoft SQL Server programmers need to understand
and work with
* Written by a leading SQL Server expert, this code-intensive guide shows beginners
how to get up to speed on Transact-SQL syntax as well as SQL Server query operations
and tools, and then demonstrates how to build applications of increasing complexity
* Addresses important topics such as full text indexing, query performance optimization,
programming techniques using views and stored procedures, application design,
and security considerations
* Covers both the 2000 and 2005 releases of SQL Server and shows how to use the
new 2005 query tool and the query editing features
Customer Reviews
Customer Reviews: 2 Average Customer Rating: Aug 20, 2007
Very Good As a Reference
I must admit, I have not read this book cover-to-cover or even through a full chapter. I use this book mainly as a reference to supplement Books Online (which I find to be a waste of time, frankly).
As a brand new Data Analyst, i've used this book to get me through basic explanations or to revisit topics i've forgotten in order to complete my job duties. I'm to the point now where I don't have to use it much, but choose to keep it handy anyway.
I guess if I had one complaint, it would be the fact that SUBSTRING and CHARINDEX methods are not explained anywhere in this book. One could argue that these functions are actually in the realm of programming, but a look through two SQL programming books reveals the absence of these two functions there as well.
String manipulation is powerful in any language, and i've found that knowledge of these two functions has really helped me with some advanced queries. Maybe the author and WROX coud take note of this.
Overall, this book is pretty good in a pinch.
Mar 19, 2007 A review from Northern Virginia
Although Technical Content good, examples are out of sync
The technical content of the text is very good, however, the reader must be aware that the examples in the "Try It Out" sections are geared for SQL Server 2000. If the reader only has SQL Server 2005 (which is included in the title) there a a significant amount of "recoding" necessary to make the examples work.
|
|
