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 XPATH statement.
B.
For each value, use the Exists() method.
C.
Use a single Exists() method.
D.
For each value, use an XPATH statement.