• ▼MSDN Library Visual Studio 6.0
  • ▶Welcome to the MSDN Library
  • ▶Visual Studio Documentation
  • ▶Visual Basic Documentation
  • ▶Visual C++ Documentation
  • ▶Visual FoxPro Documentation
  • ▶Visual InterDev Documentation
  • ▶Visual J++ Documentation
  • ▶Visual SourceSafe Documentation
  • ▶Tools and Technologies
  • ▶Microsoft Office Development
  • ▼Platform SDK
    • ▶What's New?
    • ▶Windows Programming Guidelines
    • ▼Database and Messaging Services
      • ▶DAO SDK
      • ▶Microsoft Data Access SDK
      • ▶Microsoft Exchange Server
      • ▶Messaging API (MAPI)
      • ▶Collaboration Data Objects
      • ▶Extending the Microsoft Exchange Client
      • ▼Microsoft SQL Server Programmer's Toolkit
        • ▶What's New in SQL Server 6.5
        • ▶SQL Server Setup
        • ▶Administrator's Companion
        • ▼Database Developer's Companion
          • ▶Before You Begin
          • ▶Overview
          • ▶Chapter 2 Working with Tables
          • ▶Chapter 3 Working with Data
          • ▼Chapter 4 Retrieving Data with Queries
            • ▼Creating Basic Queries
              • Identifiers
              • Choosing a Database: USE
              • SELECT Syntax
              • ▼Choosing Columns: The Select List
                • Choosing All Columns: SELECT *
                • Choosing Specific Columns
                • Specifying the Order of Columns
                • Renaming Columns in Query Results
                • Categorizing or Renaming Data in Query Results
                • Replacing Data in Query Results
                • Quoted Strings in Column Headings
                • Character Strings and Quotation Marks
                • Character Strings in Query Results
              • ▶Computed Values in the Select List
              • Eliminating Duplicates: DISTINCT
              • Specifying Tables: The FROM Clause
              • ▶Selecting Rows: The WHERE Clause
              • Creating a New Table for Results: SELECT INTO
              • Sorting Query Results: ORDER BY
              • Generating Summary Rows: COMPUTE BY
              • ▶The UNION Operator
            • ▶Using Joins to Create Multitable Queries
            • Using Summary Queries
            • ▶Using Subqueries
            • ▶Displaying Totals with GROUP BY or COMPUTE
            • ▶Using Built-in Functions
          • ▶Chapter 5 Optimizing Performance
          • ▶Chapter 6 Using Stored Procedures and Triggers
        • ▶Transact-SQL Reference
        • ▶Programming SQL Distributed Management Objects
        • ▶Guide to Microsoft Distributed Transaction Coordinator
        • ▶Programming ODBC for SQL Server
        • ▶Programming DB-Library for C
        • ▶Programming DB-Library for Visual Basic
        • ▶Programming Open Data Services
        • ▶Glossary 6.0
    • ▶Graphics and Multimedia Services
    • ▶Internet/Intranet/Extranet Services
    • ▶Networking and Distributed Services
    • ▶COM and ActiveX Object Services
    • ▶Setup and Systems Management Services
    • ▶User Interface Services
    • ▶Windows Base Services
    • ▶Reference
  • ▶SDK Documentation
  • ▶DDK Documentation
  • ▶Windows Resource Kits
  • ▶Specifications
  • ▶Knowledge Base
  • ▶Technical Articles
  • ▶Backgrounders
  • ▶Books
  • ▶Partial Books
  • ▶Periodicals
  • ▶Conference Papers