▼
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