You are developing an application that queries a Microsoft SQL Server database. The application will package the results of the query as XML data. The XML data will be retrieved directly from the database and transmitted electronically to a business partner. The query must retrieve all rows and all columns from a database table named Customers. Which query should you use?
A.
SELECT * FROM Customers FOR XML AUTO
B.
SELECT * FOR XML FROM Customers
C.
SELECT * FROM Customers as XMLDATA
D.
SELECT * FROM OPENXML( ‘<Customers>’, ‘/Root/Customer’, 1) with (CustomerID varchar(10))