SQL Server 2000 Programming by Example [With CDROM]

by Fernando Guerrero and Carlos Rojas

Book Overview

SQL Server 2000 Programming by Example provides clear and concise examples of basic programming techniques used in SQL Server 2000 primarily using Transact-SQL. Even if you're a complete novice to SQL... This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 0789724499
• ISBN13: 9780789724496
• Release Date: April 2001
• Publisher: Que
• Length: 790 Pages
• Weight: 2.93 lbs.
• Dimensions: 1.8" x 7.4" x 9.1"

Customer Reviews

Practical Hands-on for Developers

I've been teaching college database classes for years, and although I prefer to teach MySQL, it's important for serious IT students to get some experience on a full-blown enterprise database server, and for that I use MS SQL Server. This is the only usable text I've found for developers who need to learn the fundamentals for constraints, triggers, stored procedures, etc. Most SQL Server books are about administration, and barely touch upon programming topics. Many of those targeting developers rely upon some custom database dreamed up by the author that pales beside the standard samples of pubs and Northwind included with the SQL Server product. The worst books trot out database basics that might be best learned using MS Access. The authors walk through every operation with standalone examples using either pubs or Northwind, with dozens of code listings for each chapter. You might need to complete a few consecutive listings, but there are no long-running dependencies where the authors want you to follow their development project from start to finish. You can dive in and out of this book at any point with no set up required. The tone is straighforward with clear explanations, definitions, and tips. No chitchat or bull gets in the way. There are some illustrative figures, but no page after page of useless screenshots. Like the Que series claims, you learn By Example--cranking out the listings yourself to see things work. A relly nice book for students or professionals from beginning to intermediate levels. Oh yeah...the price is right.

Excelent, the best you can buy !!!

I have been working more than four years with SQL Server, since version 6.5. In my work I have to cover all the funcionality in SQL Server as I am developer, administrator and so on. I have few SQL books as I find is quite simple to find almost anything in the BOLs.But this book is the best I have ever seen to get into SQL Server and improve your skills, from the point of view of a developer there is not better book. It is also a incredible source of information for experts, it really explores all the new features you can find in SQL Server 2000.I also know the two authors's work as they help many people in the SQL forums and I can say they are really good.Enjoy it!!!

Great all-purpose SQL Server developer's book

I bought this book at the same time I got Veria's book and this one is by far the better of the two. Where Rob's book just skims the surface of important topics, this book actually goes into the details. You can definitely tell these guys write real applications. Definitely a recommended buy.

Great Book, Great Examples

When we needed to get up to speed on SQL Server 2000, we wrestled with the pros and cons of several books before deciding on this one. And it has lived up to billing, provide clear concise instruction on the ins and outs of SQL Server 2000, with excellent examples to reinforce the concepts. For those new to SQL and SQL Server 2000 specifically, a must have!

Excellent reference for any DBA

This book is an excellent reference for anyone needing assistance on stored procedures, triggers, cursors, or TSQL. The detail very good and the examples helpful. Pair this book with a good reference for administration, and the DBA library is complete.