Missing nodes() method in SQL Server 2008 RC2

Viewed 4735

I'm trying to query using a XPath expression. My Microsoft SQL Server 2008 RC2 knows the functions value() and query() but is missing the nodes() method.

Example:

SELECT Data.nodes('/root/ids/id') As id FROM myTable

Data is a XML column in the table myTable.

Is it required to install the nodes() method somehow?

1 Answers
Related