Which of the following syntax is valid ?
A. SET SHOWPLAN_XML { ON | OFF }
B. SET SHOWPLAN { ON | OFF }
C. SET SHOW_XML { ON | OFF }
D. None of the mentioned
Answer:A
Which of the following syntax is valid ?
A. SET SHOWPLAN_XML { ON | OFF } B. SET SHOWPLAN { ON | OFF } C. SET SHOW_XML { ON | OFF } D. None of the mentioned
Explanation:SET SHOWPLAN_XML causes SQL Server not to execute Transact-SQL statements. 2. Point out the correct statement :