Retrieve XML data values with XQuery in SQL Server 2005
...retrieve XML columns, variables and parameters. In this tip, you'll learn how to use two XQuery methods within your T-SQL statements: Value() to retrieve a single XML value and Query() to retrieve multiple XML values
