SQL Server 2000 Programming Style Applications: 100 Examples

Author: Wangguan Technology
Publisher:
Publish Date: 2002-03-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, through 100 examples, how to establish and maintain databases, create and maintain indexes, maintain data integrity, query, analyze, and summarize data in SQL Server 2000. It also emphasizes 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 BookManage database, and its backup can be found on the CD-ROM. Restore it to a SQL Server 2000 database for use. This book can serve as a textbook for database training classes at different levels for SQL Server 2000, as well as a command reference manual for consultation.