PrepAway - Latest Free Exam Questions & Answers

Which query should you use?

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?

PrepAway - Latest Free Exam Questions & Answers

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))


Leave a Reply