ADO Support for SQL Server XML Features

ADO applications can use the Microsoft OLE DB Provider for SQL Server (SQLOLEDB) to use the XML features of Microsoft® SQL Server™ 2000. Applications can:

• Use template queries. A template is a valid XML document, containing one or more SQL queries.
  
  
• Use XML Views on the database. XML Views provide a mapping from an XML document to a relational database. The mapping is done by annotating an XML-Data Reduced Schema. Once the XML View is defined, an XPath query can be executed to retrieve data from the database.
  
  
• Use the OpenXML extension to Transact-SQL. OpenXML provides a relational view on an XML document by allowing stored procedures to process XML and generate rowsets from the data for use by Transact SQL statements.