Explanation:It must be the only statement in a batch. 6. The document containing the XML schema for the XML output by SET STATISTICS XML is located at :
A. \Microsoft SQL Server\100\Tools\Binn\schemas\sqlserver\2004\07\showplan\showplanxml.xml
B. \Microsoft SQL Server\100\Tools\Binn\schemas\sqlserver\2004\07\showplan\showplanxml.xsl
C. \Microsoft SQL Server\100\Tools\Binn\schemas\sqlserver\2004\07\showplan\showplanxml.xsd
D. None of the mentioned
Answer:A
Explanation:It must be the only statement in a batch. 6. The document containing the XML schema for the XML output by SET STATISTICS XML is located at :
A. \Microsoft SQL Server\100\Tools\Binn\schemas\sqlserver\2004\07\showplan\showplanxml.xml B. \Microsoft SQL Server\100\Tools\Binn\schemas\sqlserver\2004\07\showplan\showplanxml.xsl C. \Microsoft SQL Server\100\Tools\Binn\schemas\sqlserver\2004\07\showplan\showplanxml.xsd D. None of the mentioned
Explanation: SET STATISTICS XML produces XML output in the form of schema 7. Which of the following is valid syntax for SET STATISTICS XML ?