SQLServer2000 Programming Design

Author: Zhang Xinyan, Editor-in-Chief
Publisher:
Publishing Time: Not Available
Features: To meet the teaching requirements of computer and related majors in higher vocational colleges and accelerate the cultivation of high-quality applied talents in China, Science Press has planned and published this series of national higher vocational and college planning textbooks. This book is one of the series. It is divided into 12 chapters and comprehensively introduces the management, application, and development of the SQL Server 2000 database system. Chapter 1 briefly introduces the basic knowledge of SQL Server 2000; Chapter 2 introduces the management of database files; Chapter 3 introduces the operations on tables and the management of data in tables; Chapter 4 introduces data integrity, constraints, defaults, and rules; Chapter 5 introduces table relationships and views; Chapter 6 provides a detailed introduction to the methods and techniques of T-SQL programming; Chapter 7 introduces the creation and usage methods of stored procedures and triggers; Chapter 8 introduces database backup and recovery techniques; Chapter 9 introduces database security management; Chapter 10 introduces some methods of system management and maintenance; Chapter 11 mainly introduces the concepts of database replication and the methods of publishing; Chapter 12 introduces the development of ODBC-based database applications. This book is a unified textbook for higher engineering education and is suitable for undergraduate and college students majoring in computer and related fields as teaching materials. It can also be used by higher vocational college students majoring in computer and is available for reference by computer engineering technical personnel.