SQL XML Example - doc2.xml

<?

xml version="1.0" encoding="utf-8"?>

<

doc xmlns = "http://blogs.msdn.com/federaldev/xmldemo">

<

header>

<

id>2</id>

<

year>2006</year>

</

header>

<

body>

<

part1>document 2 - part 1</part1>

<

part2>document 2 - part 2</part2>

<

part3>document 2 - part 3</part3>

</

body>

</

doc>