Topics Covered

• Using SQL-Server to extract recordset data in XML format - examples will show various SQL statements retrieving data from single tables, header/detail tables and the situation where multiple level queries are involved.
• How to use a Delphi application and ADO to extract XML data
• How to extract relational (recordset) data from an XML document using SQL
• How to integrate SQL-Server 2000 with Internet Information Server to facilitate queries using the firewall friendly HTTP protocol. Examples will include URL based queries and template based queries.
• Using XSL stylesheets in combination with templates to "shape" raw XML data into HTML

SQL/XML Demos