Home Forums Article Discussions Article Discussions by Author Discuss content posted by Wayne Sheffield Loading XML Data into SQL Server (SQL Spackle) RE: Loading XML Data into SQL Server (SQL Spackle)

  • January 12, 2011 at 12:24 am

    #1272205

    Anil Maharjan (1/11/2011)

    Hello all,

    Well finally what we concluded then cannot we import the complex XML data file or what ?.

    I think that the only conclusions we can draw are:

    1. If the input is well-formed XML then we can import it using the given method.

    2. HTML is NOT, in general, well-formed XML

    3. (Contentious.) Well-formed XML elements can only contain HTML data if they are within a CDATA block.

    Kelsey Thornton
    MBCS CITP