Binding: Paperback Dewey Decimal Number: 005.2768 EAN: 9780735621978 ISBN: 0735621977 Label: Microsoft Press Manufacturer: Microsoft Press Number Of Items: 1 Number Of Pages: 544 Publication Date: June 14, 2006 Publisher: Microsoft Press Sales Rank: 29407 Studio: Microsoft Press
Product DescriptionThis thorough, hands-on reference for database developers and administrators delivers expert guidance on sophisticated uses of Transact-SQL (T-SQL)—one of the most familiar and powerful programming languages for SQL Server. Written by a T-SQL guru, this guide focuses on language features and how they are interpreted and processed by the SQL Server execution engine. You’ll get in-depth coverage of the sophisticated uses of T-SQL, including triggers, user-defined functions, exception handling, and more. The book explains and compares solutions to database-development problems in both SQL Server 2000 and SQL Server 2005, discussing the new T-SQL programming features added to SQL Server 2005 in detail. Includes extensive code samples, table examples, and logic puzzles to help database developers and administrators understand the intricacies and help promote mastery of T-SQL.
Customer Reviews
Average Rating:
Rating: - Very little actual T-SQL
Book actually has very limited T-SQL. Mostly triggers, USP, functions, but little actual code.
Rating: - Too clever by half
Please see review by C. Mialaret. S/he is spot on.
One gets the impression that the author may have been more focused on impressing you with his eruditeness, rather than writing a practical book with useful examples and clear explanations.
Affecianados of Kalen Delaney's 'Inside SQL Server 2000' will be disappointed.
Rating: - Useful but COULD be much better. Needs major editorial intervention.
You should think of this book as of the second volume of the two-volume set on the 2005-Server SQL. If you get this one, you'll get the other one too; neither tome is self-sufficient; in fact there's a lot of explicit interdependence. This book, Programming, deals with slightly more esoteric features than the first tome, Querying -- although I can't say you must read the first entire volume before touching this one. Both books can be read at the same time (but see what I say about the target reader ... Read More
Rating: - T-SQL Book at Its Best!!!!!!!!!!
This book has lots of sample code for developers to follow. I bought a book "Advanced Transact-SQL for SQL Server 2000" written by Itzik Ben-gan about five years and loved the book. This book did great job in the SQL Scripts where you might need to spent sometime read through it.
This book is a gem for SQL developers!!! Highly recommanded!!!
Rating: - Excelent
This book is a must-have, even for those who uses other SQL Databases... Totally Amazing!
- Very little actual T-SQL
- Too clever by half
- Useful but COULD be much better. Needs major editorial intervention.
- T-SQL Book at Its Best!!!!!!!!!!
