You have a table named Products.Product. The table has columns ProductID, Name, Size, and Category. You have a variable named @XML with following XML value:

<Root> <Category Name="Socks" /> <Category Name="Pants" /> <Category Name="Shirts" /> </Root> You are tasked to write a query that lists the products in Products. Product that match the categories listed in the XML document. You need to write a query to accomplish the task. Which query should you write?

Question

You have a table named Products.Product. The table has columns ProductID, Name, Size, and Category. You have a variable named @XML with following XML value:

<Root> <Category Name="Socks" /> <Category Name="Pants" /> <Category Name="Shirts" /> </Root> You are tasked to write a query that lists the products in Products. Product that match the categories listed in the XML document. You need to write a query to accomplish the task. Which query should you write?

Accepted Answer

C. WITH XMLTable

Answer

A. SELECT p.ProductID, p.Name, p.Size, p.Category

Answer

B. SELECT p.ProductID, p.Name, p.Size, p.Category

Answer

D. WITH XMLTable

You have a table named Products.Product. The table has columns ProductID, Name, Size, and Category. You have a variable named @XML with following XML value: <Root> <Category Name="Socks" />…

Question

Options

How the community answered

Community Discussion