▼
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
Overview of Accessing and Changing Data
▶
Query Tools and Programming Interfaces
▶
Transact-SQL Syntax Elements
▶
Accessing and Changing Data Fundamentals
▶
Query Fundamentals
▼
Advanced Query Concepts
▶
Using Aggregate Functions in the Select List
▶
Grouping Rows with GROUP BY
▶
Combining Results with UNION
▼
Subquery Fundamentals
Subquery Rules
Qualifying Column Names in Subqueries
▼
Subquery Types
Subqueries with Aliases
Subqueries with IN
Subqueries with NOT IN
Subqueries in UPDATE, DELETE, and INSERT Statements
Subqueries with Comparison Operators
Comparison Operators Modified by ANY, SOME, or ALL
Subqueries with EXISTS
Subqueries with NOT EXISTS
Using EXISTS and NOT EXISTS to Find Intersection and Difference
Subqueries Used in Place of an Expression
Multiple Levels of Nesting
▶
Correlated Subqueries
Conditional Data Processing Using CASE
▶
Summarizing Data
▶
Error Handling
Querying SQL Server System Catalogs
▶
Managing ntext, text, and image Data
▶
Full-text Querying SQL Server Data
▶
Full-text Querying of File Data
▶
Distributed Queries
▶
OLE Automation Objects in Transact-SQL
▶
Solutions to Common Query Puzzles
▶
Transact-SQL Tips
▶
Adding Data
▶
Changing Data
▶
Deleting Data
▶
Transactions
▶
Cursors
▶
Locking
▶
Optimizing Database Performance
▶
Replication
▶
Data Transformation Services
▶
OLAP Services
▶
English Query
▶
Repository
▶
Building SQL Server Applications
▶
Troubleshooting
▶
How To
▶
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