This post aims to be a quick reference source for the beginners and shows a few simple SELECT examples.   Reading attributes from an XML variable DECLARE @x XML SET @x = '<author fname="Michael" lname="Howard" />' Read More......(<a href="http://sqlserver-qa.net/blogs/extblog/archive/2010/07/01/xquery-lab-62-revisiting-simple-tsql-select-operations-using-xquery.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=9191" width="1" height="1">