▼
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
▶
Using Joins to Create Multitable Queries
Using Summary Queries
▼
Using Subqueries
Subquery Syntax
Subquery Rules
Subquery Examples
Subqueries Introduced with IN
Subqueries Introduced with NOT IN
Qualifying Column Names
Multiple Levels of Nesting
Subqueries in UPDATE, DELETE, and INSERT Statements
Subqueries with Aliases
▶
Comparison Operator Subqueries
▶
Correlated Subqueries
▼
Subqueries Introduced with EXISTS
Subqueries with EXISTS Examples
Subqueries Introduced with NOT EXISTS
Using EXISTS and NOT EXISTS to Find Intersection and Difference
Subqueries Used in Place of an Expression
▶
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