SQL Server Database Programming

Author: Zhang Xiuyu
Publisher:
Publish Date: 2006-01-01
Features: This book follows the principle of sufficient theory and focuses on practical application. It takes the development process of a complete "Book Lending System" as the main line to introduce the various functions, application methods, and development processes of SQL Server 2000. The book is divided into five parts: Part one introduces the functions to be learned from the database example in this book and covers basic database knowledge. Part two focuses on databases, tables, views, creating indexes, and database queries. Part three mainly introduces T-SQL language, database programming, stored procedures, and triggers. Part four covers database performance management, transaction management, and database backup and restoration. The fifth part combines the use of VB6.0's ADO to operate SQL Server 2000, explaining the development process, methods, and techniques of the book lending and management system. Each chapter provides exercises and experiments to help reinforce the learned knowledge. This book can be used as a textbook for computer-related majors in colleges and vocational schools, as well as for SQL Server database application system developers.