When SET SHOWPLAN_ALL is ON, SQL Server returns execution information for each statement without executing it.

Options
- True
- False


CORRECT ANSWER : True

Discussion Board
SET SHOWPLAN_ALL

The above statement is true. When SET SHOWPLAN_ALL is ON, SQL Server returns execution information for each statement without executing it, and Transact-SQL statements are not executed. After this option is set ON, information about all subsequent Transact-SQL statements are returned until the option is set OFF. SET SHOWPLAN_ALL is intended to be used by applications written to handle its output.

Prajakta Pandit 03-8-2017 05:32 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement