You have a table that has an XML column named XMLOrderHeader. You need to design a stored procedure that extracts the order header values and stores them in a table. The solution must meet the following requirements:
* Extract many values
* Minimize the development effort
What should the solution include?
A.
Use a single Exists() method.
B.
Use a single XPATH statement.
C.
For each value, use the Exists() method.
D.
For each value, use an XPATH statement.