Product Description

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 Server 2000 programming, you will benefit by reading through the book's logical process. SQL Server 2000 is introduced and explored, database structure is designed and built, and finally a variety of programming techniques are studied and reviewed. If you are already familiar with SQL Server 2000 programming, you may use the book as a quick reference guide that provides plenty of pertinent examples.

Product Details

• Amazon Sales Rank: #438113 in Books
• Published on: 2001-04-26
• Original language: English
• Number of items: 1
• Binding: Paperback
• 792 pages

Amazon.co.uk Review
Ideal for the database programmer or system DBA, Microsoft SQL Server 2000 Programming by Example is an excellent example-based tutorial on mastering today's SQL features. Packed with plenty of tips and tricks, this title will let almost anyone do more with SQL Server.

While there are plenty of screen shots showing graphical SQL Server tools, the focus of this book is clearly on learning real command-line Transact-SQL (T-SQL). The authors provide a patient and very thorough tour of T-SQL with full coverage of both basic and advanced features. You'll learn how to define new tables, manage users in groups, as well as perform all kinds of queries. Stand-out material includes an excellent guide to SQL data types and how to choose the right one for your needs. When it comes to queries, the book does a great job of exploring all your options for joining relational data, as well as grouping data for more advanced reporting. True to its title, Microsoft SQL Server 2000 Programming by Example is filled with dozens of examples of SQL commands (and the results) so that you can try out this material for yourself and really learn the language thoroughly.

Later on, the authors turn toward server-side programming with a digestible guide to creating stored procedures and triggers. The book closes with an in-depth guide to the issues regarding cursors (for working with table data), transactions and locking. Sections on bulk copy tools and the Microsoft Data Transformation Services (DTS) show how to move data around the enterprise. A final section of distributed queries and linked servers will help you work with different sources of data wherever it resides in your organisation.

Despite some stilted writing, the comprehensive examples in this book make it a success. It will let anyone start using basic T-SQL for the first time, as well as teach more advanced readers to master the finer points of Microsoft databases. --Richard Dragan

From the Author
SQL 2000 Programming for beginners... plus some surprises
SQL 2000 Programming for beginners... plus some surprises

From the Back Cover

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 Server 2000 programming, you will benefit by reading through the book's logical process. SQL Server 2000 is introduced and explored, database structure is designed and built, and finally a variety of programming techniques are studied and reviewed. If you are already familiar with SQL Server 2000 programming, you may use the book as a quick reference guide that provides plenty of pertinent examples.

Customer Reviews

A++ Execellent hands on intermediate/advanced level book
With previous experience (v7.0) I found this book an excellent guide to the added functionality of v2000.

It's concisely, cleanly written in a straightforward no-nonsense style. The lay out is logical and well planned with the book building nicely as you move through it.

I have also found it deep enough to fill some gaps and clarify areas that I previously felt I knew very well.

The main advantage of the book to my mind though is that it does exactly what it says on the cover - it provides pratical examples of all the concepts discussed (I have found that previous books have often left me feeling "OK, but lets see it in action!!!" including Soukup & Delaney's excellent "Inside SQL Server 7".

All round an excellent book, highly recommended at a very reasonable price.

Great book to learn SQL Server 2000
This book is one of the best Technical books you can buy to learn SQL Server 2000. Very easy to follow and with some good examples. If you have used other databases such as Access, this book provides a reasonable basis to step up to a larger database system.

Offcourse you will need practical experience to fully utilize what you learn, but gives you a good basis to start. After reading this book you should have little problems. Good luck

A must have for SQL Server 2000, and exam 70-229
I wasnt sure how useful this book would be to me as I am already a MCSD & MCT with intermediate SQL Server experience. I read this book cover to cover and it managed to fill in many gaps in my general SQL Server knowledge, as well as the new features of SQL Server 2000. No subject is left uncovered, and from a developer's perspective, the "by example" approach really helps, as you can check your understanding of a topic by looking at the example. The authors style is simple and precise without being at all boring.

As for the exam, I found this a great all-round book that helped with most of the areas. (And yes I passed this morning!)

I will definitely keep this book as a handly SQL reference from now on.