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...
Main Author: | |
---|---|
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