XQuery - Session 9
In SQL 2005, XML has gone native and with the now native XML type is the need to query effectively and efficiently. Thus the use of XQuery. XQuery allows a XML file to be queried in place and only the resulting values returned. XQuery is a super-set of XPath, and additional functions. It is a pretty large and complex set of functions and properties, but fairly easy to read and learn (since it is plain text, doesn't need a compiler and is fairly verbose)
Here is the link to the sample code I demo'ed during the webcast. I ran over again, so take a few minutes and look over the sample code.Most of it is pretty straight forward and makes goos sense when you see it.
http://www.neudesic.com/uploads/steve_muise/09_XQuery.zip
Let me kow if you have any further questions.
Steve