SQL Server 2000 Application Development Program

Author: He Wenhua
Publisher:
Publish Date: 2004-08-01
Features: This book includes two parts: the use and development of SQL Server 2000, and the development of database applications using Visual Basic and SQL Server. It introduces the functions, operating mechanisms, and operational methods of SQL Server 2000, with a focus on the management and operation of SQL Server 2000's server-side and client-side. The book covers the management of data and various database objects in SQL Server 2000, database backup and recovery operations, the security system and management methods of the database, database replication, server management, and network applications. It also introduces Transact-SQL language and its application development. Additionally, it explains how to develop database applications using Visual Basic, including: the basics of Visual Basic database development; Visual Basic data controls and database objects; accessing and operating SQL Server 2000 databases in Visual Basic; and Visual Basic data reporting. Each chapter of the book is meticulously designed following the general principles of teaching and learning, emphasizing the intrinsic connections between different knowledge areas. It connects database development and application system development into a unified whole, implementing various functional parts of a student management system. All the examples in the book are compiled together to form a complete student management database application system, accompanied by original source code (code), which is published on the teaching resource website of the Electronics Industry Press. This book can serve as a textbook for vocational and technical colleges' computer and information technology majors, as well as for university computer science and technology, electronic, and automation applied undergraduate majors in the course of "Database Application Development." It can also be used as a reference for computer science professionals and software development engineering technicians.