SQL Server 2000 Database Programming

Author: Liang Fangming
Publisher: Beijing Hope Electronic Press
Publish Date: 2002-11-01
Features: This book is rich in content, well-structured, filled with examples, illustrated, and written in fluent language. It serves as the training for the Microsoft Certified Advanced Technical Training Center and can also be used as a textbook for various database training classes, for higher education institutions' database courses, and as a reference for database management and development personnel. This book is part of the Microsoft Certified Advanced Technical Training series, corresponding to exam number 70-229 and course numbers 2071, 2073. SQL Server 2000 is the newest version in the SQL Server family, extending the performance, reliability, quality, and usability of its previous versions. SQL Server 2000 also introduces several new features, making it an excellent database platform for large-scale online transaction processing (OLTP) and e-commerce applications. It also adds support for XML and enhances data warehousing capabilities.
The book covers the basics of SQL Server from Chapters 1 to 8, introducing how to program using Transact-SQL statements, the creation and planning of tables, indexes, etc. Chapters 9 to 16 focus on the flexible application of the preceding knowledge, including complex query techniques, views, stored procedures, triggers, custom functions, and transactions and locks. The appendix includes key vocabulary used in SQL Server 2000, along with some commonly used commands and examples.