Code Centric: T-SQL Programming with Stored Procedures and Triggers (Paperback)

~ Garth Wells (Author)
Key Phrases: editor pane, results pane, search screen, Query Analyzer, Books Online, Enterprise Manager (more...)

Editorial Reviews

Product Description

<p>If you want to learn how to write stored procedures and triggers for Microsoft SQL Server, <i>Code Centric: T-SQL Programming with Stored Procedures and Triggers</i> is the book for you. You'll learn real-world coding and how to build non-trivial applications. All of the examples covered in the book are available for download, making it easier to work through over 5,000 lines of sample code. <p> While there is extensive coverage of the new functionality in SQL Server 2000&emdash;such as UDFs (user-defined functions)&emdash;you can use this book effectively for virtually any version of SQL Server&emdash;6.x, 7.0, or 2000.

<p> The book starts with a comprehensive overview of Transact-SQL, and goes on to cover a variety of topics including data types, the SELECT statement and JOIN operations, control-of-flow statements, updating and deleting data, Transact-SQL built-in functions, user-defined functions, and views. <p>The second part provides coverage of the stored procedures and triggers available in SQL Server, including system stored procedures, extended stored procedures, user-defined stored procedures, and triggers. <p>In the third part, Garth explores the database portion of a real-world solution, demonstrating how to create the client-side portion using ASP and ADO. He also shows how to design a database project from start to finish by using a browser-based application from a provided set of specifications. This book showscases more indispensable information about the major components of Microsoft SQL Server's Transact-SQL language than any other book on the market.

About the Author

He has designed and implemented database solutions for over 7 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 <i>SQL Server Professional</i> and he is the coauthor of <i>10 Projects You Can Do with Microsoft SQL Server 7</i>.

Product Details

• Paperback: 692 pages
• Publisher: Apress (February 15, 2001)
• Language: English
• ISBN-10: 1893115836
• ISBN-13: 978-1893115835
• Product Dimensions: 8.7 x 7.5 x 1.7 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.com Sales Rank: #78,730 in Books (See Bestsellers 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 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

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 (St. Charles, MO USA) - See all my reviews

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.