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.