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。
technet.microsoft.com
2.
If SET ANSI_NULLS is not specified, the setting of the ANSI_NULLS option of the current database applies.
如果未指定SETANSI_NULLS，则应用当前数据库的ANSI_NULLS选项设置。
technet.microsoft.com
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。
technet.microsoft.com
4.
When SET ANSI_NULLS is ON, an operator that has one or two NULL expressions returns UNKNOWN.
当SETANSI_NULLS为ON时，带有一个或两个NULL表达式的运算符返回UNKNOWN。
msdn2.microsoft.com
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，然后该连接才能执行分布式查询。
msdn2.microsoft.com
6.
For more information about the ANSI_NULLS database option, see ALTER DATABASE (Transact-SQL) and Setting Database Options.
有关ANSI_NULLS数据库选项的详细信息，请参阅ALTERDATABASE（Transact-SQL）和设置数据库选项。
technet.microsoft.com
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设置在执行存储过程时都将被忽略。
technet.microsoft.com
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才会影响比较。
technet.microsoft.com
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。
technet.microsoft.com
10.
When SET ANSI_NULLS is ON, all comparisons against a null value evaluate to UNKNOWN.
当SETANSI_NULLS为ON时，所有对空值的比较均取值为UNKNOWN。
technet.microsoft.com