109 out of 117 rated this helpful - Rate this topic

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

Check out SQLXML information on the Data Access and Storage DeveloperCenter

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.

In This Library Section	Essentials
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	SQLXML 3.0 SP2 SQLXML Downloads XML and Internet Support Overview (SQL Books Online) SQLXML Support Resources Newsgroup

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)