SQL Server 2005 t-SQL: The Use of the nodes() Method for SQL Types; Converting XML Data into SQL Types

DECLARE @xml xml

SET @xml = ' <Root> <Item>one</Item> <Item>two</Item> <Item>three</Item> <Item>four</Item> <Item>five</Item> </Root> '

SELECT Temp.Items.value('.','varchar(16)') AS [Items] FROM @xml.nodes('//Item') AS Temp(Items)

/* For general information, see “Introduction to XQuery in SQL Server 2005” http://technet.microsoft.com/en-us/library/ms345122.aspx */

mod date: 2008-01-16T01:38:06.000Z