SQL Server 2000 Database and Applications

Author: Li Weihong
Publisher:
Publish Date: 2007-01-01
Features: This book systematically and comprehensively introduces the installation and configuration of the large-scale database management system SQL Server 2000, as well as common techniques and practical methods for database development using SQL Server 2000. The content of the book is divided into two parts: The first part focuses on the implementation of SQL Server 2000 database application techniques, including an overview of SQL Server 2000, the creation and management of databases, the creation and management of data tables, the design and implementation of data integrity, the creation and maintenance of indexes, the creation and maintenance of views, Transact-SQL language, the creation and maintenance of stored procedures and triggers, and the use and management of transactions and locks. The second part focuses on the implementation of SQL Server 2000 database management techniques, including the security management of SQL Server 2000, data conversion in SQL Server 2000, backing up and restoring databases, SQL Server 2000 agent services, data replication in SQL Server 2000, and distributed queries. This book takes the practical application of SQL Server 2000 as its starting point and is divided into two main parts for writing. During the writing process, it emphasizes explaining specific database examples and adopts a picture-and-text comparison approach, making it easy to understand. This book is an ideal tutorial for learning the SQL Server 2000 database management system. It can serve as a teaching material for students in universities and colleges studying SQL Server 2000, as well as a practical reference book for teachers and database programmers who teach related courses.