SQL Server 2000 Application Development Tutorial

Author: He Wenhua, Li Ping
Publisher:
Publish Date: 2005-02-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. It covers the management of data and various database objects in SQL Server 2000, as well as operations such as database backup and recovery. The book also discusses the security system and management methods of databases, replication, server management, and network applications. Additionally, it covers the Transact-SQL language and its application development. The book introduces the use of Visual Basic to develop database applications, 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 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 undergraduate majors in computer science and technology, electronic and automation at universities. It can also be used as a reference book for computer science professionals and software development engineers.