SQL SERVER 2000 Programming Design

Author: Zhang Yanqing
Publisher:
Publish Date: 2005-07-07
Features: SQL Server 2000 not only incorporates many new features to improve system performance but also makes database management easier. In addition to introducing related content about SQL Server 2000 programming, this book also provides detailed explanations of important topics such as databases, tables, indexes, views, and stored procedures. The specific content includes: SQL Server operational environment, SQL Query Analyzer, database and table creation, table joins, T-SQL programming, stored procedures, BCP utility and SQLScript, triggers, creating views, creating indexes, creating full-text search, creating CURSOR, transactions and locking. This book is rich in content and examples, making it a valuable learning reference for database management and database programming professionals.