You are working with a table that has an XML column that contains information about books. Each
book may have an associated price.
You need to write with a query that returns the price of each book as a non-xml value.
Which XML method should you use?
A . Exist()
B . Nodes()
C . Query()
D . Value()
Answer: D
Explanation:
References: https://docs.microsoft.com/en-us/sql/t-sql/xml/nodes-method-xml-datatype?view=sql-server-2017