Code Centric and over one million other books are available for Amazon Kindle. Learn more


or
Sign in to turn on 1-Click ordering.
or
Amazon Prime Free Trial required. Sign up when you check out. Learn More
More Buying Choices
Have one to sell? Sell yours here
Code Centric: T-SQL Programming with Stored Procedures and Triggers
 
 
Start reading Code Centric on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

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

Garth Wells (Author)
3.7 out of 5 stars  See all reviews (16 customer reviews)

List Price: $44.95
Price: $34.16 & this item ships for FREE with Super Saver Shipping. Details
You Save: $10.79 (24%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.
Want it delivered Monday, January 30? Choose One-Day Shipping at checkout. Details

Formats

Amazon Price New from Used from
Kindle Edition $28.77  
Paperback $34.16  

Book Description

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.

Frequently Bought Together

Code Centric: T-SQL Programming with Stored Procedures and Triggers + Writing Stored Procedures for Microsoft SQL Server + Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET
Price For All Three: $97.62

Show availability and shipping details

Buy the selected items together
  • In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details

  • Writing Stored Procedures for Microsoft SQL Server $27.57

    In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details

  • Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET $35.89

    In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details



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

16 Reviews
5 star:
 (7)
4 star:
 (4)
3 star:    (0)
2 star:
 (3)
1 star:
 (2)
 
 
 
 
 
Average Customer Review
3.7 out of 5 stars (16 customer reviews)
 
 
 
 
Share your thoughts with other customers:
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 
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.

Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


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.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


5 of 5 people found the following review helpful:
4.0 out of 5 stars Good book as a reference., April 18, 2002
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.

Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No

Share your thoughts with other customers: Create your own review
 
 
 
Most Recent Customer Reviews











Only search this product's reviews



Inside This Book (learn more)
Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
editor pane, results pane, search screen, data dictionary, stolen bases, use tempdb, sysmessages table, current compatibility level, role sysadmin, data modification statements, information schema views, audit trail functionality, dbo system, system stored procedures, extended stored procedures, inner query, sales engagement, looping operation, unique clustered index, other set operation, procedure defaults, printed error messages, diskette icon, statement permissions, dbo user
Key Phrases - Capitalized Phrases (CAPs): (learn more)
Query Analyzer, Books Online, Enterprise Manager, Object Browser, Alfreds Futterkiste, User-Defined Stored Procedures, Built-in Functions, Data Definition Language, Server Agent, Crystal Reports, Fabrica Inter, Ana Trujillo Emparedados, Cancel Help Figure, Third Order, Second Order, Statement Permissions Permission, Click Tools, Con Email, Query Optimizer, Program Files, Manage Indexes, Com Name, Order Details, Vice President of Leasing, Hank Aaron
Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Back Cover | Surprise Me!
Search Inside This Book:

What Other Items Do Customers Buy After Viewing This Item?


Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
 

Your tags: Add your first tag
 

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Listmania!


Create a Listmania! list

So You'd Like to...


Create a guide


Look for Similar Items by Category


Look for Similar Items by Subject