Programming ADO SQL Server Applications
    Getting Started with ADO
       ADO Syntax Conventions
       System Requirements for ADO
       ADO and OLE DB Provider Installation
       ADO File Locations
       Upgrading the Catalog Stored Procedures
       Using ADO in Different Development Environments
          Visual Basic and ADO
          Visual C++ and ADO
          Web-Based Applications and ADO
       Adding a Data Source
       Deleting a Data Source
    Creating an ADO Application
    Connecting to a SQL Server Data Source
       Connecting to Multiple Instances of SQL Server
       Retrieving Connection Properties
    Executing Queries
       Using the Command Object
       Using the Connection Object
       Constructing an SQL Statement
       Using Parameters
       Executing Statements
          Executing Statements Directly
          Executing Prepared Statements
       Executing Stored Procedures
          Using Return Code and Output Parameters for Stored Procedures
       Executing User-Defined Functions
       Using Batch Updates
       Generating Multiple Recordsets
    Processing Results
       Using the Recordset Object
       Using the Fields Collection and Field Object
       Determining the Characteristics of a Result Set
       Mapping Data Types
          Data Type Usage Considerations
    Using Cursors with ADO
       Using Default Result Sets
       Using Server Cursors with ADO
       Scrolling and Retrieving Rows
          Bookmarking Rows
    Performing Transactions in ADO
    Handling Errors and Messages in ADO
    Handling Data Definition Language
    Managing Long Data Types
    ADO Support for SQL Server XML Features
       XML-Related Properties
       Using Streams for Command Input
       Retrieving Result Sets into Streams
       Mapping an XML Schema to a Relational Schema Using Annotated Schemas
       ADO Support for OpenXML
 SQL Server ADO Programmer's Reference
    Objects
       Command Object
       Connection Object
       Record Object
       Recordset Object
       Stream Object
    Dynamic Properties
       A
          Access Order Property
          Active Sessions Property
          Asynchable Abort Property
          Asynchable Commit Property
          Autocommit Isolation Levels Property
       B
          Base Path Property
          Blocking Storage Objects Property
          Bookmark Type Property
          Bookmarkable Property
       C
          Catalog Location Property
          Catalog Term Property
          Change Inserted Rows Property
          Column Definition Property
          Column Privileges Property
          Column Set Notification Property
          Command Time Out Property
          Connect Timeout Property
          Content Type Property
          Current Catalog Property
          Cursor Auto Fetch Property
       D
          Data Source Property
          Data Source Name Property
          Data Source Object Threading Model Property
          DBMS Name Property
          DBMS Version Property
          Defer Column Property
          Defer Prepare Property
          Delay Storage Object Updates Property
       E
          Extended Properties Property
       F
          Fetch Backwards Property
       G
          GROUP BY Support Property
       H
          Heterogeneous Table Support Property
          Hold Rows Property
       I
          IAccessor Property
          IColumnsInfo Property
          IColumnsRowset Property
          IConnectionPointContainer Property
          IConvertType Property
          Identifier Case Sensitivity Property
          Immobile Rows Property
          Initial Catalog Property
          IRowset Property
          IRowsetChange Property
          IRowsetIdentity Property
          IRowsetInfo Property
          IRowsetLocate Property
          IRowsetResynch Property
          IRowsetScroll Property
          IRowsetUpdate Property
          ISequentialStream Property
          Isolation Levels Property
          Isolation Retention Property
          ISupportErrorInfo Property
       L
          Literal Bookmarks Property
          Literal Row Identity Property
          Locale Identifier Property
          Lock Mode Property
       M
          Mapping Schema Property
          Maximum Index Size Property
          Maximum Open Rows Property
          Maximum Pending Rows Property
          Maximum Row Size Property
          Maximum Row Size Includes BLOB Property
          Maximum Rows Property
          Maximum Tables in SELECT Property
          Multiple Parameter Sets Property
          Multiple Results Property
          Multiple Storage Objects Property
          Multi-Table Update Property
       N
          Notification Granularity Property
          Notification Phases Property
          NULL Collation Order Property
          NULL Concatenation Behavior Property
       O
          Objects Transacted Property
          OLE DB Version Property
          OLE Object Support Property
          Open Rowset Support Property
          ORDER BY Columns in Select List Property
          Others' Changes Visible Property
          Others' Inserts Visible Property
          Output Encoding Property
          Output Parameter Availability Property
          Output Stream Property
          Own Changes Visible Property
          Own Inserts Visible Property
       P
          Pass By Ref Accessors Property
          Password Property
          Persist Security Info Property
          Persistent ID Type Property
          Prepare Abort Behavior Property
          Prepare Commit Behavior Property
          Preserve on Abort Property
          Preserve on Commit Property
          Procedure Term Property
          Prompt Property
          Provider Friendly Name Property
          Provider Name Property
          Provider Version Property
       Q
          Quick Restart Property
       R
          Read-Only Data Source Property
          Reentrant Events Property
          Remove Deleted Rows Property
          Report Multiple Changes Property
          Return Pending Inserts Property
          Row Delete Notification Property
          Row First Change Notification Property
          Row Insert Notification Property
          Row Privileges Property
          Row Resynchronization Notification Property
          Row Threading Model Property
          Row Undo Change Notification Property
          Row Undo Delete Notification Property
          Row Undo Insert Notification Property
          Row Update Notification Property
          Rowset Conversions on Command Property
          Rowset Fetch Position Change Notification Property
          Rowset Release Notification Property
       S
          Schema Term Property
          Schema Usage Property
          Scroll Backwards Property
          Server Cursor Property
          Server Data on Insert Property
          Skip Deleted Bookmarks Property
          SQL Support Property
          SS STREAM FLAGS Property
          Strong Row Identity Property
          Structured Storage Property
          Subquery Support Property
       T
          Table Term Property
          Transaction DDL Property
       U
          Unique Rows Property
          Updatability Property
          Use Bookmarks Property
          User ID Property
          User Name Property
       W
          Window Handle Property
       X
          XML Root Property
          XSL Property
    Provider Support for ADOX
 ADO Samples
    ADO Connection and Error Handling
    ADO and Long Data Types (Visual Basic)
    ADO and Long Data Types (C++)
    ADO and Long Data Types (Web)
    ADO Web Application
    ADO and FOR XML
    ADO and Open XML
    ADO and XPath Query