Date: Oct. 23, 2000
Link: http://support.microsoft.com/support/kb/articles/q271/7/75.asp?FR=0&SD=MSDN
Source Author or Organization: Microsoft Developer Network

This sample illustrates the process of retrieving an Active Data Objects (ADO) Recordset from an input XML document by using OpenXML, a feature of SQL Server 2000.

OpenXML.exe is a SQL Server 2000 extension to Transact-SQL that allows stored procedures to process XML and generate rowsets. To examine the sample, download the OpenXML.exe file posted on this page and follow the steps to compile and run it.

The program creates a stored procedure on a SQL Server 2000 database and passes an XML document to the stored procedure. The stored procedure processes the document using OpenXML and returns an ADO Recordset.