documentation
.HELP!
ADO and SQL Server Documentation
N
ADO and SQL Server
previous page
next page
ADO and SQL Server
N
previous page
start
next page
Menu
Homepage
Table of contents
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
Get in touch
Submit feedback about this site to:
[email protected]