Which XML method should you use?

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()

View Answer

Answer: D

Explanation:

References: https://docs.microsoft.com/en-us/sql/t-sql/xml/nodes-method-xml-data­type?view=sql-server-2017