Stairway to XML: Level 5 - The XML exist() and nodes() Methods

Posted on SQL Server Central See other posts from SQL Server Central
Published on Mon, 15 Oct 2012 06:00:00 UT Indexed on 2012/10/18 23:11 UTC
Read the original article Hit count: 317

Filed under:

The XML exist() method is used, often in a WHERE clause, to check the existence of an element within an XML document or fragment. The nodes() method lets you shred an XML instance and return the information as relational data.

SQL Developer Bundle 12 essential tools for database professionals
The SQL Developer Bundle contains 12 tools designed with the SQL Server developer and DBA in mind. Try it now.

© SQL Server Central or respective owner