• ▼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