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.
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