大家在查： SETSHOWPLAN_TEXT 查德阿大田弘子 ShowplanSET SETSHOWPLAN_ALL Ermitage SLOT1 HirokoSanders 白剂 Setspn.exe

SHOWPLAN_ALL

SHOWPLAN_ALL

SHOWPLAN_ALL

SHOWPLAN_ALL

1

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

不能在存储过程中指定 SETSHOWPLAN_TEXT 和 SETSHOWPLAN_ALL 。

2

SET SHOWPLAN_ALL returns more detailed output intended to be used with programs designed to handle its output .

SETSHOWPLAN_ALL 则返回更详细的输出，以使专门处理其输出的程序进行处理。

3

The additional result set contains the SHOWPLAN_ALL columns for the query and these additional columns .

附加结果集包含查询的 SHOWPLAN_ALL 列以及下面的附加列。

4

Any SET statement can be specified inside a stored procedure, except SET SHOWPLAN_TEXT and SET SHOWPLAN_ALL.

可以在存储过程中指定除了 SETSHOWPLAN_TEXT 和 SETSHOWPLAN_ALL 以外的任何 SET 语句。

5

SET SHOWPLAN_ALL is intended to be used by applications written to handle its output .

SETSHOWPLAN_ALL 是供为处理其输出而编写的应用程序使用的。

6

Showplan All occurs when a query is executed .

ShowplanAll 在执行查询时发生。

7

This is the compile time counterpart of the Showplan All event .

它是 ShowplanAll 事件的编译时对等事件。

8

When SET SHOWPLAN_ALL is OFF , SQL Server executes the statements without generating a report .

如果 SETSHOWPLAN_ALL 为 OFF ，则 SQLServer 将执行语句，但不生成报表。

热词推荐

大家在看