Skip to main content
  • Book
  • © 2001

Beginning SQL Server 2000 Programming

Apress

Authors:

  • Provides excellent tutelage for novice database programmers or those migrating from desktop solutions such as Access who are interested in developing solutions with SQL Server

  • Shows how to create and delete databases, tables, relationships, and indexes with the interactive tolls of SQL Server, and through the Transact-SQL language

  • Takes readers through how to build a sample database and shows how to design with solutions in mind

  • 3060 Accesses

Buy it now

Buying options

eBook USD 34.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever

Tax calculation will be finalised at checkout

Other ways to access

This is a preview of subscription content, log in via an institution to check for access.

Table of contents (21 chapters)

  1. Front Matter

    Pages N2-xiv
  2. Introduction

    • Robin Dewson
    Pages 1-6
  3. SQL Server 2000 Installation

    • Robin Dewson
    Pages 7-58
  4. Managing SQL Server

    • Robin Dewson
    Pages 59-88
  5. Query Analyzer

    • Robin Dewson
    Pages 89-136
  6. Database Analysis and Design

    • Robin Dewson
    Pages 137-150
  7. Creating the Sample Database

    • Robin Dewson
    Pages 151-188
  8. Defining Tables

    • Robin Dewson
    Pages 189-228
  9. Creating Indexes

    • Robin Dewson
    Pages 229-264
  10. Building Relationships

    • Robin Dewson
    Pages 265-284
  11. Diagramming the Database

    • Robin Dewson
    Pages 285-322
  12. Database Backups and Recovery

    • Robin Dewson
    Pages 323-366
  13. Maintaining Your Database

    • Robin Dewson
    Pages 367-386
  14. Inserting Data

    • Robin Dewson
    Pages 387-418
  15. Retrieving Data

    • Robin Dewson
    Pages 419-456
  16. Updating Data and Transactions

    • Robin Dewson
    Pages 457-476
  17. Deleting Data

    • Robin Dewson
    Pages 477-488
  18. Building a View

    • Robin Dewson
    Pages 489-520
  19. Stored Procedures

    • Robin Dewson
    Pages 521-554
  20. Advanced Stored Procedures

    • Robin Dewson
    Pages 555-578

About this book

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 mind. If you are migrating from a desktop solution such as Access to SQL Server, this book will provide you with clear and practical demonstrations of the relevant tasks at every stage in the process. Once you've mastered the basics of SQL Server, you'll move on to learn more advanced techniques. By the end of this book, you'll have a firm grasp of the most important SQL Server features and be able to develop your own effective database solutions.

About the author

Robin Dewson has been hooked on programming ever since he bought his first computer, a Sinclair ZX80, in 1980. He has been working with SQL Server since version 6.5 and Visual Basic since version 5. Robin is a consultant mainly in the city of London, where he has been for nearly eight years. He also has been developing a rugby-related website as well as maintaining his own site at Fat-Belly.com.

Bibliographic Information

  • Book Title: Beginning SQL Server 2000 Programming

  • Authors: Robin Dewson

  • DOI: https://doi.org/10.1007/978-1-4302-0804-4

  • Publisher: Apress Berkeley, CA

  • eBook Packages: Springer Book Archive

  • Copyright Information: Robin Dewson 2001

  • eBook ISBN: 978-1-4302-0804-4Published: 01 January 2008

  • Edition Number: 1

  • Number of Pages: XIV, 792

  • Number of Illustrations: 1265 b/w illustrations

  • Topics: Software Engineering/Programming and Operating Systems

Buy it now

Buying options

eBook USD 34.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever

Tax calculation will be finalised at checkout

Other ways to access