• ▼MSDN Library - April 2000
    • ▶Welcome to the MSDN Library
    • ▶Visual Studio 6.0 Documentation
    • ▶Office Developer Documentation
    • ▶Windows CE Documentation
    • ▼Platform SDK
      • ▶Getting Started
      • ▶Design Strategies and Standards
      • ▶Base Services
      • ▶Component Services
      • ▼Data Access Services
        • ▶Microsoft Data Access Components (MDAC) SDK
        • ▶Jet and Replication Objects
        • ▶Microsoft XML SDK
        • ▼Microsoft SQL Server Programmer's Toolkit
          • ▶Getting Started
          • ▶What's New
          • ▶Installing SQL Server
          • ▶SQL Server Architecture
          • ▶Administering SQL Server
          • ▶Creating and Maintaining Databases
          • ▼Accessing and Changing Data
            • Overview of Accessing and Changing Data
            • ▶Query Tools and Programming Interfaces
            • ▶Transact-SQL Syntax Elements
            • ▶Accessing and Changing Data Fundamentals
            • ▼Query Fundamentals
              • Parts of a SELECT Statement
              • ▶Using the Select List
              • ▶Using the FROM Clause
              • ▶Filtering Rows with WHERE and HAVING
              • Sorting Rows with ORDER BY
              • ▼Join Fundamentals
                • ▼Using Joins
                  • Using Inner Joins
                  • Using Outer Joins
                  • Using Cross Joins
                  • Using Self-Joins
                  • Joining Three or More Tables
                • Null Values and Joins
                • Specifying Joins in FROM or WHERE Clauses
            • ▶Advanced Query Concepts
            • ▶Adding Data
            • ▶Changing Data
            • ▶Deleting Data
            • ▶Transactions
            • ▶Cursors
            • ▶Locking
          • ▶Optimizing Database Performance
          • ▶Replication
          • ▶Data Transformation Services
          • ▶OLAP Services
          • ▶English Query
          • ▶Repository
          • ▶Building SQL Server Applications
          • ▶Troubleshooting
          • ▶How To
          • ▶Glossary
      • ▶Graphics and Multimedia Services
      • ▶Management Services
      • ▶Messaging and Collaboration Services
      • ▶Networking and Directory Services
      • ▶Security
      • ▶Tools and Languages
      • ▶User Interface Services
      • ▶Web Services
      • ▶Win32 API
    • ▶SDK Documentation
    • ▶DDK Documentation
    • ▶Windows Resource Kits
    • ▶Knowledge Base
    • ▶Technical Articles
    • ▶Backgrounders
    • ▶Specifications
    • ▶Books
    • ▶Partial Books
    • ▶Periodicals
    • ▶Samples