大家在查：投入冒险新玩家 MHSM 海维斯旺斯顿石坎 ·迪耶特 countersink rainworm Energon

SETANSI_NULLS

SETANSI_NULLS

SETANSI_NULLS

SETANSI_NULLS

1

If SET ANSI_NULLS is not specified , the setting of the ANSI_NULLS option of the current database applies .

如果未指定 SETANSI_NULLS ，则应用当前数据库的 ANSI_NULLS 选项设置。

2

When SET ANSI_NULLS is ON , an operator that has one or two NULL expressions returns UNKNOWN .

当 SETANSI_NULLS 为 ON 时，带有一个或两个 NULL 表达式的运算符返回 UNKNOWN 。

3

Therefore , any client session settings for SET QUOTED_IDENTIFIER and SET ANSI_NULLS are ignored when the stored procedure is running .

因此，所有客户端会话的 SETQUOTED_IDENTIFIER 和 SETANSI_NULLS 设置在执行存储过程时都将被忽略。

4

When SET ANSI_NULLS is OFF , comparisons of all data against a null value evaluate to TRUE if the data value is NULL .

当 SETANSI_NULLS 为 OFF 时，如果数据值为 NULL ，则所有数据对空值的比较将取值为 TRUE 。

5

When SET ANSI_NULLS is ON , all comparisons against a null value evaluate to UNKNOWN .

当 SETANSI_NULLS 为 ON 时，所有对空值的比较均取值为 UNKNOWN 。

6

The example also shows that IS NULL is not affected by the SET ANSI_NULLS setting .

该示例还表明，ISNULL 不受 SETANSI_NULLS 设置的影响。

热词推荐

大家在看