• ▼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
          • ▶Optimizing Database Performance
          • ▶Replication
          • ▶Data Transformation Services
          • ▶OLAP Services
          • ▶English Query
          • ▶Repository
          • ▶Building SQL Server Applications
          • ▶Troubleshooting
          • ▼How To
            • ▶Installing SQL Server
            • ▼SQL Server Enterprise Manager
              • ▶Administering SQL Server
              • ▶Creating and Maintaining Databases
              • ▼Accessing and Changing Data
                • How to access the Query Designer to view a table (Enterprise Manager)
                • How to access the Query Designer to design a view (Enterprise Manager)
                • How to access the Query Designer in Data Transformation Services (Enterprise Manager)
                • How to open panes in the Query Designer (Enterprise Manager)
                • How to hide panes in the Query Designer (Enterprise Manager)
                • How to add all columns for one input source (Enterprise Manager)
                • How to add all columns for all input sources (Enterprise Manager)
                • How to remove a column from the query (Enterprise Manager)
                • How to reorder columns for output (Enterprise Manager)
                • How to create a table alias (Enterprise Manager)
                • How to create a column alias (Enterprise Manager)
                • How to verify an SQL statement (Enterprise Manager)
                • How to execute a query (Enterprise Manager)
                • How to stop a query (Enterprise Manager)
                • How to clear query results (Enterprise Manager)
                • How to print query results (Enterprise Manager)
                • How to enter search conditions (Enterprise Manager)
                • How to exclude duplicate rows from the result set (Enterprise Manager)
                • How to specify an OR condition (Enterprise Manager)
                • How to specify an AND condition (Enterprise Manager)
                • How to specify an OR condition for two different columns (Enterprise Manager)
                • How to specify an AND condition for two different columns (Enterprise Manager)
                • How to combine conditions when AND has precedence (Enterprise Manager)
                • How to combine conditions when OR has precedence (Enterprise Manager)
                • How to define an EXISTS subquery in the Grid pane (Enterprise Manager)
                • How to define a subquery in the SQL pane (Enterprise Manager)
                • How to display an expression in the result set (Enterprise Manager)
                • How to sort using an expression (Enterprise Manager)
                • How to use an expression as a condition (Enterprise Manager)
                • How to use an expression as a search value (Enterprise Manager)
                • How to summarize values for all rows (Enterprise Manager)
                • How to count all the rows in a table (Enterprise Manager)
                • How to count all the rows that meet a condition (Enterprise Manager)
                • How to count the values in a column (Enterprise Manager)
                • How to group rows (Enterprise Manager)
                • How to specify a condition for a group (Enterprise Manager)
                • How to specify a WHERE condition in an aggregate query (Enterprise Manager)
                • How to specify a custom expression for a summary value (Enterprise Manager)
                • How to manually join tables (Enterprise Manager)
                • How to create an outer join (Enterprise Manager)
                • How to create a self-join (Enterprise Manager)
                • How to remove a join (Enterprise Manager)
                • How to specify an unnamed parameter (Enterprise Manager)
                • How to specify a named parameter (Enterprise Manager)
                • How to specify parameter marker characters (Enterprise Manager)
                • How to edit data in the Results grid pane (Enterprise Manager)
                • How to add a new data row (Enterprise Manager)
                • How to delete a row (Enterprise Manager)
                • How to create an Update query (Enterprise Manager)
                • How to create an Insert query (Enterprise Manager)
                • How to create a Delete query (Enterprise Manager)
                • How to create an Insert Values query (Enterprise Manager)
                • How to create a Make Table query (Enterprise Manager)
              • ▶Optimizing Database Performance
              • ▶Replication
              • ▶Data Transformation Services
            • ▶Transact-SQL
            • ▶OLE DB
            • ▶ODBC
          • ▶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