大家在查：查德阿大田弘子 ShowplanSET SETSHOWPLAN_ALL celra SHOWPLAN_ALL Ermitage SLOT1 HirokoSanders 白剂

SETSHOWPLAN_TEXT

This statement is similar to SET SHOWPLAN_TEXT, except that the output is in a format more verbose than that of SHOWPLAN_TEXT.

SET SHOWPLAN_TEXT and SET SHOWPLAN_ALL cannot be specified in a stored procedure .

When SET SHOWPLAN_TEXT is OFF, SQL Server executes statements without generating a report with execution plan information .

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