One of the very interesting features added to SQL Server 2005 is the support for XML data type and XQuery. Working with XML variables and XML columns would seem little tricky, initially. However, after interacting with it for some time, anyone would realize that it is not complicated at all.
I had been writing a series of articles which explains different ways to access and manipulate XML data using TSQL. This week, my column at SQLServerCentral discusses various ways to read values from an XML variable.