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
FOR XML AUTO, ROOT(‘ProductExport’)
B. SELECT Price [@Price],ProductName AS [*]
FROM Products
FOR XML PATH(‘Product’),ROOT(‘ProductExport’)
C. SELECT Price, ProductName
FROM Products AS ProductExport
FOR XML PATH(‘Product’)
D. SELECT Price [@Price], ProductName AS [*]
FROM Products AS ProductExport
FOR XML AUTO, ELEMENTS
