Rating: 5 out of 5
Easy to comprehend book for beginner and advanced user alike
I have never worked with SQL Server before. This is the first time that I learn TSQL and Stored Procedures for my web project. I found the book to be extremely easy to follow, there are a lot of To-The-Point code examples.As the results of this excellent book I have learned in 3 months how to do things that are considered advanced in TSQL programming: 1. Create SQL Statements with dynamic columns names that you pass them in as parameters. 2. Immitate Array (not available in TSQL) by using Min() and Max() functions. 3. Return Multiple recordsets to the web page reduces my original ASP code of 32 database calls to a single database call. 4. Do batch insert with dynamic number of insert statement by passing parameter by string and use TSQL string functions to get each of the variable in the string to build dynamic multiple insert statements (another array immitation). I am amused that after 3 months I have digested most of the materials in the book. This is a Must-Buy book if you want to learn stored procedures. Most of other book in the shelves cover just about the same topics but requires you to have working knowledge of SQL to comprehend.
Rating: 5 out of 5
Awesome
As a consultant, I occasionally meet and work with talented individuals who have the natural ability to unfold complex problems into manageable sections and explain them in simple and understandable terms. The authors of this book successfully achieve this status. This book caters to all users, from beginners to experts. It includes lots of tips, tricks and pitfall warning notes for the casual user right through to intense documentation for the seasoned pro. The authors do a wonderful job of unraveling the complexities of Stored Procedures through simple and concise examples for real world applications.Thorough coverage of the SQL Server Environment will help even the novice to quickly harness the power of SQL Server and turn it into a productivity tool. The concepts are easy to follow with step by step instructions and documented results. There are lots of examples and screen shots to support the authors' theories and help illustrate stored procedure behaviours. Finally, a book that explains how to debug Stored Procedures using available tools and techniques which the average reader can access. This book will help beginners journey through the complexities of SQL Server and Stored Procedures. The Sample Asset tracking database is a much needed alternate to PUBS and gives the reader a fresh perspective on database design. The chapters on Advanced Stored Procedure Programming and XML Documentation are excellent features of this book. The authors do an exemplary job of presenting structured programing techniques and encourage readers to follow industry standard practices. The authors have left virtually no stone unturned in their quest for thoroughness in explaining and documenting the features and flexibility of Stored Procedures. This book belongs on the desk of every serious developer and DBA. It is a wonderful reference book and a source of many solutions to those nagging problems that cause too many of us to lose sleep and our hair.
Rating: 4 out of 5
well written
The book is well written with many good samples. I use it whenever I get in a bind on Stored Proc programming. The only problem is that, unlike other publishers (Wrox), there is no available code samples online. One great thing about Wrox books is that if I want to see a sample work, I don't have to retype the whole thing. This publisher should work on that feature.
| 
View My Shopping Cart
Email this page to a friend
Correction/Comment/Suggestion Regarding This Page?
