Question

Point out the wrong statement.

(a) SET SHOWPLAN_XML can be specified inside a stored procedure

(b) SET SHOWPLAN_XML returns information as a set of XML documents

(c) SET SHOWPLAN_XML is intended to return output as nvarchar(max) for applications such as the sqlcmd utility

(d) All of the mentioned

The question was asked in final exam.

My question is based upon Query Execution Plan in section Performance Tuning and Optimization of SQL Server

Answer 1

Correct choice is (a) SET SHOWPLAN_XML can be specified inside a stored procedure

For explanation I would say: It must be the only statement in a batch.