▼
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
Parts of a SELECT Statement
▼
Using the Select List
Choosing All Columns
Choosing Specific Columns
Constants in Query Result Sets
Computed Values in the Select List
Assigning Result Set Column Names
Delimiting Result Set Column Names
Eliminating Duplicates with DISTINCT
Limiting Result Sets Using TOP and PERCENT
▶
Using the FROM Clause
▶
Filtering Rows with WHERE and HAVING
Sorting Rows with ORDER BY
▶
Join Fundamentals
▶
Advanced Query Concepts
▶
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