⟩ Do you know what is XPath?
XPath is a language defined by the W3C, used to select nodes from XML documents. SQL Server 2000 supports XPath language that helps to retrieve data from XML documents. To do so, SQL server uses a mapping schema to define an XML based view of the data in one or more SQL Server tables and views. The mapping schema is then used to retrieve data.