SQLServer2000 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 covers the implementation of SQL Server 2000 database application techniques, including an overview of SQL Server 2000, database creation and management, table creation and management, the design and implementation of data integrity, index creation and maintenance, view creation and maintenance, Transact-SQL language, the creation and maintenance of stored procedures and triggers, and the use and management of transactions and locks. The second part covers the implementation of SQL Server 2000 database management techniques, including security management in 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 with 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 teaching related courses.