SQL SERVER 2000 Programming Style Applications - 100 Examples

Author: Webcor Technologies Compiler
Publisher:
Publish Date: 2002-08-01
Features: SQL Server 2000 extends the performance, reliability, quality, and usability of SQL Server 7.7, becoming an excellent database platform for large-scale online transaction processing (OLTP), data warehousing, and e-commerce applications. This book introduces comprehensively, through 100 examples, how to establish and maintain databases, create and maintain indexes, maintain data integrity, query, analyze, and statistics in SQL Server 2000. It also focuses on how to use Transact-SQL, create stored procedures, and create and use user-defined functions. All the examples in this book are completed in the database BookManage. The backup of this database can be found on the CD-ROM, and you can restore it to a SQL Server 2000 database for use. This book can serve as a textbook for database training classes of different levels for SQL Server 2000, as well as a command reference manual for consultation.