SQLXML

SQLXML enables XML support for SQL Server 2000, bridging the gap between XML and relational data. You can create an XML view of your existing relational data and work with it as if it were an XML file. SQLXML is your solution if you need to:
Query a relational database with XPath
Query a relational database with Transact-SQL and return XML results
Update relational data as if it was XML
Convert XML data into relational data and load it into an existing SQL Server 2000 database
Query SQL Server via URLs from your Web browser or Web application
Access SQL Server XML functionality via OLEDB/ADO
Access SQL Server XML functionality via .NET Framework classes

SQLXML and other programmability features of SQL Server are highlighted in the Data Access and Storage Developer Center. The XML Developer Center also features information on XML and the Database.


IIS Virtual Directory Management for SQL Server
Retrieving XML Documents by Using FOR XML on the Client Side
Creating XML Views by Using Annotated XSD Schemas
Using Updategrams to Modify Data
SQLXML 3.0 Data Access Components
SQLXML .NET Support
Web Services (SOAP) Support in SQLXML