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

by Garth Wells

Book Overview

1 Transact-SQL Overview.- 2 Data Types.- 3 Data Definition Language.- 4 DML: SELECT, JOINs, and Control-of-Flow.- 5 DML: Inserting, Updating, and Deleting Data.- 6 Built-In Functions.- 7 User-Defined Functions.- 8 Views.- 9 System Stored Procedures.- 10 Extended Stored Procedures.- 11 User-Defined Stored Procedures.- 12 Triggers.- 13 Procedures and Triggers by Example.- 14 Building an Application.- Appendix A HTML Primer.- Before You Get Started.-...

• Format: Paperback
• Language: English
• ISBN: 1893115836
• ISBN13: 9781893115835
• Release Date: January 2001
• Publisher: Apress
• Length: 695 Pages
• Weight: 2.85 lbs.
• Dimensions: 1.5" x 7.4" x 9.2"

Customer Reviews

taken me out of tight spots

I love this book because it's not so much about theory (leave that in college or for newbies) it's more about how to apply code to real-world problems. something that I find hard to find. :-)like it.

Real code, real situations, real productivity

I compared this book with several others & it stands head and shoulders above them. The extensive coding provides examples that not only explain "how-to" for those familiar with T-SQL, but also provide "Oh, you can do THAT?" types of functionality for those becoming familiar with the language. This probably shouldn't be the first book in one's SQL reference library as not all the material would be appropriate for beginners ... but if your interests/work take you onto the programming side, this is a must-have.

Excellent book on SQLServer 2000

Really it is an excellent book for SQL server.iam new programmer to SQLserver 2000.i tired with trying to learn many books on SQLServer2000. Only this book i picked up very Fast.i don't know why some reviewers not satisfied with this book...

The T-SQL manual

Garath Wells book is a unique guidance to T-SQL programming.In "easy to read terms" the book explains working with T-SQL and gives you the basic skills to write effective Stored Procedures and triggers.The book gives many, easy to understand examples that help you build your own code. I often use the book as a T-SQL-manual. Many of my existing SQL server applications has now been tuned to run mush faster with less code thanks to the skills I developed though this book.If you are new to Stored Procedures or just want to learn more - don't hesitate to buy "Code-Centric: T-SQL Programming with Stored Procedures and Triggers"

Full of sample code

This book is full of well documented code samples that clearly explain concepts presented in the book. The author provides different levels of code which allow beginners to gain proficiency and experienced developers to learn alternative approaches to solve problems. There is a real focus on using Transact-SQL as a programming language to solve real-world problems.I urge you to visit the web site for the book (SQLBook.com) and download the sample chapters. That will give you a good idea of the book's content and level of detail. You can also look through the table of contents. I found Code Centric to be helpful and informative.