A guide to Microsoft Transact-SQL, this book offer information, explanations, and advice you need to master Transact-SQL and develop the best possible Transact-SQL code. It is a useful reference for those working with this database development language. The accompanying CD-ROM includes the complete set of code examples found in the book.

Shows how to build and use relational databases with SQL. This book helps you to: discover how to Use SQL in a client/server system; build a multitable relational database; construct nested and recursive queries; set up database security; use SQL within applications; and, map SQL to XML.

Offering a tutorial to the themes and techniques involved in applying the SQL language, this book includes coverage of versions of major commercial SQL platforms. It also covers MySQL, and PostgreSQL. It contains examples which have been tested against each SQL platform, with incompatibilities or platform distinctives called out and explained.

A reference to frequently used SQL statements and commonly used SQL functions, this work helps programmers, database administrators, and everyone who uses SQL in their day-to-day work.

Provides a guide to programming with SQL Server 2000, from a tutorial on Transact-SQL to a discussion of features, such as indexed views, user-defined functions, and the SQL Server features to support XML. Database administration is also covered, but only as it affects the SQL Server developer. This book is intended for the SQL Server developer.

Offers solutions to challenges and conveys the way you need to think in order to get the most out of SQL programming efforts for both correctness and performance. This edition teaches various advanced techniques that can be used with any product, in any SQL environment, whether it is an SQL-92 or SQL-99 environment.