A Survey of Microsoft SQL Server 2000 XML Features from Andrew Conrad
This describes latest features on XML with SQL Server with abstract example - Worth of reading
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnexxml/html/xml03172004.asp