Helaas...deze pagina is niet beschikbaar in het Nederlands. Klik hier om terug te gaan of lees verder in het Engels.

Real World XML processing in SQL Server 2005

Area: SQL Server 2005 | Level: Intermediate

It’s increasingly difficult as a SQL DBA or developer to avoid having to deal with XML data from external sources. Since the introduction of the XML native datatype in SQL Server 2005 it’s simple to store and query XML data within databases, but how do you go about transforming XML data with fixed schemas into SQL datasets?

The various commands and concepts involved are explained at considerable length in SQL Server Books Online, but when I needed to parse Excel 2002-generated XML data I found that the information and examples provided didn’t address the problems I was facing, particularly those relating to the fixed schema imposed by Excel. In this article, I hope to explain the problems and solutions in some depth. It may look complicated at first glance but if you examine each part (and read the related Books Online topics) then it should quickly become clear. The general principles apply to all fixed-schema XML data... (continues as PDF)

Download the entire article as a PDF file...
Get a free PDF reader here...

Related Downloads

XML_Processing.zip