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
Get up to speed on SQL Server 2000 and how to take full advantage of new features
Who said you can find all the contents from Book On line? Does Book On Line has the same easy to follow structure plus the good examples that really help to learn and pratice? Read morePublished on July 9 2004
I bought this book at the same time I got Veria's book and this one is by far the better of the two. Read morePublished on March 16 2002 by Joe Hornsby
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. Read morePublished on Dec 17 2001 by John Madison