Beginning SQL Server 2000 Programming

Microsoft SQL Server 2000 provides enterprise-class database solutions, offering interactive development tools and complete management of your relational database applications. In this book, you'll build a sample database with SQL Server and in the process learn how to design with solutions in...

Full description

Bibliographic Details
Main Author: Dewson, Robin
Format: eBook
Language:English
Published: Berkeley, CA Apress 2001, 2001
Edition:1st ed. 2001
Subjects:
Online Access:
Collection: Springer Book Archives -2004 - Collection details see MPG.ReNa
Table of Contents:
  • SQL Server 2000 Installation
  • Managing SQL Server
  • Query Analyzer
  • Database Analysis and Design
  • Creating the Sample Database
  • Defining Tables
  • Creating Indexes
  • Building Relationships
  • Diagramming the Database
  • Database Backups and Recovery
  • Maintaining Your Database
  • Inserting Data
  • Retrieving Data
  • Updating Data and Transactions
  • Deleting Data
  • Building a View
  • Stored Procedures
  • Advanced Stored Procedures
  • XML and Data Retrieval
  • Triggers