• In your situation, where the XML is in a strongly structured, regular format it will probably be advantageous to shred it and store it in relational form.

    Without even needing to store the data in an XML column, however, you can still use the SQL Server platform to:

    1) validate the XML against an XML Schema,

    2) shred the original XML document and store it in your database directly,

    3) regenerate the XML from the relational data using the built-in XML functionality (FOR XML PATH clause, for instance),

    4) generate the HTML page for you (using FLWOR expressions or the SQLCLR),

    5) and accept requests/deliver the HTML page directly to you (via HTTP Endpoints)

    One of the chief advantages (IMHO) of the XML data type is that (unlike the old TEXT, NTEXT, and IMAGE LOB data types) you don't have to create columns to hold your XML data in order to take full advantage of its power and flexibility.