大家在查：企业孵化器 field intensity contiguity 马德才改组计划 ssvnc 瓜分豆剖 million job 尼尔• snowfalls

ANSI_NULLS

ANSI_NULLS

ANSI_NULLS

ANSI_NULLS

1

The ANSI_NULLS option must have been set to ON for the execution of all CREATE TABLE statements that create tables referenced by the view .

要执行所有 CREATETABLE 语句以创建视图引用的表，ANSI_NULLS 选项必须设置为 ON 。

2

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

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

3

The ANSI_NULLS and QUOTED_IDENTIFIER options must have been set to ON when the CREATE VIEW statement was executed .

当执行 CREATEVIEW 语句时，ANSI_NULLS 和 QUOTED_IDENTIFIER 选项必须设置为 ON 。

4

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

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

5

A connection must have the ANSI_NULLS and ANSI_WARNINGS options set ON before the connection can execute distributed queries .

必须先将连接的 ANSI_NULLS 和 ANSI_WARNINGS 选项设置为 ON ，然后该连接才能执行分布式查询。

6

For more information about the ANSI_NULLS database option , see ALTER DATABASE (Transact-SQL ) and Setting Database Options .

有关 ANSI_NULLS 数据库选项的详细信息，请参阅 ALTERDATABASE （Transact-SQL ）和设置数据库选项。

7

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 设置在执行存储过程时都将被忽略。

8

SET ANSI_NULLS ON affects a comparison only if one of the operands of the comparison is either a variable that is NULL or a literal NULL .

仅当某个比较操作数是值为 NULL 的变量或文字 NULL 时，SETANSI_NULLSON 才会影响比较。

9

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 。

10

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

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

热词推荐

大家在看