You need to generate the following XML document.
<ProductExport>
<Product Price=”99″>Product1</Product>
<Product Price=”199″>Product2</Product>
<Product Price=”299″>Product3</Product>
<Product Price=”399″>Product4</Product>
</ProductExport>
Which query should you use?
A.
SELECT Price, ProductName
FROM Products AS ProductExport
FOR XML PATH(‘Product’)
B.
SELECT Price, ProductName
FROM Products
FOR XML AUTO, ROOT(‘ProductExport’)
C.
SELECT Price [@Price],
ProductName AS [*]
FROM Products AS ProductExport
FOR XML AUTO, ELEMENTS
D.
SELECT Price [@Price],
ProductName AS [*]
FROM Products
FOR XML PATH(‘Product’),ROOT(‘ProductExport’)