Code Centric: T-SQL Programming with Stored Procedures and Triggers [Paperback]

Garth Wells (Author)

Book Description

Publication Date: February 15, 2001

The key to increasing your SQL Programming skills is to understand and implement well-formulated examples that demonstrate how to solve problems you are likely to face in your programming endeavors. Garth Wells does this by laying the foundation of Transact-SQL basics and building on this foundation with real-world examples that are based on his 5-years of experience working with SQL Server. This book covers the fundamentals of Transact-SQL with heavy concentration on Stored Procedures. There are more than 5000 lines of sample code and complete examples that show how to implement functionality you are likely to use as a SQL programmer.
About the author:
Garth Wells is President of DataDrivenWebSites.com, Inc., a company that focuses on Web-enabling SQL Server databases. He has designed and implemented database solutions for over seven years, and has successfully implemented database solutions in a number of different industries including computer design, medical informatics, and commercial real estate management. Garth has written for Pinnacle Publishing's newsletter, SQL Server Professional and is the co-author of 10 Projects You Can Do with Microsoft SQL Server 7.

Editorial Reviews

About the Author

Garth Wells is president of DataDrivenWebSites.com, Inc., a company that focuses on web-enabling SQL Server databases. He has designed and implemented database solutions for over seven years, and has successfully implemented database solutions in a number of different industries including computer design, medical informatics, and commercial real estate management. Garth has written for Pinnacle Publishing's newsletter SQL Server Professional and he is the co-author of 10 Projects You Can Do with Microsoft SQL Server 7.

Product Details

• Paperback: 692 pages
• Publisher: Apress (February 15, 2001)
• Language: English
• ISBN-10: 1893115836
• ISBN-13: 978-1893115835
• Product Dimensions: 9.2 x 7.4 x 1.5 inches
• Shipping Weight: 2.6 pounds (View shipping rates and policies)
• Average Customer Review: 3.7 out of 5 stars  See all reviews (16 customer reviews)
• Amazon Best Sellers Rank: #814,525 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

11 of 13 people found the following review helpful:

1.0 out of 5 stars You have got to be kidding, February 28, 2001

By 

Kris Smith (Redmond, WA) - See all my reviews

This review is from: Code Centric: T-SQL Programming with Stored Procedures and Triggers (Paperback)

This is quite easily the worst technical book I've ever even begun to read. "5000 lines" of source code? Only if you count gratuitous use of space-filling comments - in many examples there are more comments than code. Real-world code? Is "real-world" a synonym for "buggy"? Easily 25% of the code samples have bugs that will prevent them from running on any version of SQL Server.

And the worst part of it all is that the book is written so poorly. Mr. Wells should definitely keep his day job.

8 of 9 people found the following review helpful:

2.0 out of 5 stars Code-centric? Error-centric is more like it!, March 11, 2001

By 

Bob Volz (St. Louis, MO) - See all my reviews

This review is from: Code Centric: T-SQL Programming with Stored Procedures and Triggers (Paperback)

I was excited when I got this book, but steadily more disappointed as I began to read it. After reading the first chapter or two, I started counting the coding errors and typing mistakes. I was up to 23 when I stopped. A lot of the code in this book simply won't run. What does is too simplistic to really be useful.

5 of 5 people found the following review helpful:

4.0 out of 5 stars Good book as a reference., April 18, 2002

By 

Brian Schkerke - See all my reviews

This review is from: Code Centric: T-SQL Programming with Stored Procedures and Triggers (Paperback)

This book introduced me to several aspects of T-SQL that many other books did not. It's dog eared and carried by me every day. It does have some technical errors but to me they were passable; that is what the website is for. (Any book produced about a technical subject that is error free will be the Holy Grail.)

The book covers primarily T-SQL and the methods of programming it. It is not meant as a primer for accessing T-SQL through ADO or DMO. The best way to access the code is through SQL's Query Analyzer, hands down. It gives an excellent introduction to the meaning behind T-SQL, including stored procedures, triggers, creating and altering all of the above. It also gives a good breakdown on the differences between MS SQL 7 and MS SQL 2000. (I believe that a good reason I didn't have the technical problems mentioned elsewhere is that this book is aimed primarily at SQL 2000 and I used it for SQL 7 so I examined everything carefully to ensure it used nothing SQL2K specific.)

I believe this book is one of a very few that cover T-SQL in any depth. It came highly recommended to me and I pass that recommendation to you. Garth does have the ability to explain technical subjects in an easy to follow format and that ability is well used in this book.