This sample application demonstrates how to use ADO to build an Active Server Page (ASP) Web application that retrieves result sets into streams using the Transact-SQL FOR XML clause.
C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Samples\ADO\XML\FORXML.asp
This ASP sample requires Microsoft® Internet Information Services (IIS) version 5.0.
Add the sample file to a Microsoft Visual InterDev® project, and then click Start.