ARITHABORT

Sample Sentence

Definition:
AllAll
Category:AllAll,OralOral,WrittenWritten,TitleTitle,TechnicalTechnical
Source:AllAll,DictionaryDictionary,WebWeb
Difficulty:AllAll,EasyEasy,MiddleMiddle,HardHard
1.
The result of an arithmetic operator is always nullable, even if the operands are nonnullable and ANSI_WARNINGS or ARITHABORT is set ON.
即使操作数不可为空并且ANSI_WARNINGS或ARITHABORT设置为ON，算术运算符的结果也始终可为空。
jí shǐ cāo zuò shù bù kě wèi kōng bìng qiě ANSI_WARNINGS huò ARITHABORT shè zhì wèi ON , suàn shù yùn suàn fú de jié guǒ yě shǐ zhōng kě wèi kōng 。
technet.microsoft.com
2.
If ANSI_WARNINGS is ON but ARITHABORT is OFF, floating point domain errors do not cause the query to be terminated.
如果ANSI_WARNINGS为ON但ARITHABORT为OFF，则浮点域错误不会导致查询终止。
rú guǒ ANSI_WARNINGS wèi ON dàn ARITHABORT wèi OFF , zé fú diǎn yù cuò wù bú huì dǎo zhì chá xún zhōng zhǐ 。
technet.microsoft.com
3.
If you are using an OLE DB or ODBC server connection, the only value that must be modified is the ARITHABORT setting.
如果使用的是OLEDB或ODBC服务器连接，则唯一必须要修改的值是ARITHABORT设置。必须使用。
rú guǒ shǐ yòng de shì OLEDB huò ODBC fú wù qì lián jiē , zé wéi yī bì xū yào xiū gǎi de zhí shì ARITHABORT shè zhì 。 bì xū shǐ yòng 。
msdn2.microsoft.com
4.
User scripts that depend upon ARITHABORT being set to OFF might be broken by this change.
此更改可能会破坏依赖于设置为OFF的ARITHABORT的用户脚本。
cǐ gēng gǎi kě néng huì pò huài yī lài yú shè zhì wèi OFF de ARITHABORT de yòng hù jiǎo běn 。
technet.microsoft.com
5.
Computed columns can be specified only if the ARITHABORT and QUOTED_IDENTIFIER database options are set to ON.
只有当ARITHABORT和QUOTED_IDENTIFIER数据库选项设置为ON时，才能指定计算列。
zhǐ yǒu dāng ARITHABORT hé QUOTED_IDENTIFIER shù jù kù xuǎn xiàng shè zhì wèi ON shí , cái néng zhǐ dìng jì suàn liè 。
technet.microsoft.com
6.
If the database compatibility level is set to 80 or earlier, the ARITHABORT option must be explicitly set to ON.
如果数据库兼容性级别设置为80或更早，则必须将ARITHABORT选项显式设置为ON。
rú guǒ shù jù kù jiān róng xìng jí bié shè zhì wèi bā shí huò gèng zǎo , zé bì xū jiāng ARITHABORT xuǎn xiàng xiǎn shì shè zhì wèi ON 。
technet.microsoft.com
7.
SET ARITHABORT must be ON when you are creating or changing indexes on computed columns or indexed views.
在对计算列或索引视图创建或更改索引时，SETARITHABORT必须为ON。
zài duì jì suàn liè huò suǒ yǐn shì tú chuàng jiàn huò gēng gǎi suǒ yǐn shí , SETARITHABORT bì xū wèi ON 。
msdn2.microsoft.com
8.
If either ANSI_WARNINGS or ARITHABORT are ON, an error is thrown instead of returning NULL value.
如果ANSI_WARNINGS或ARITHABORT为ON，则将引发错误，而不是返回NULL值。
rú guǒ ANSI_WARNINGS huò ARITHABORT wèi ON , zé jiāng yǐn fā cuò wù , ér bú shì fǎn huí NULL zhí 。
technet.microsoft.com
9.
If the database is running in 80 compatibility mode or earlier, the ARITHABORT option must be set to ON.
如果数据库在80或更低的兼容模式下运行，则ARITHABORT选项必须设置为ON。
rú guǒ shù jù kù zài bā shí huò gèng dī de jiān róng mó shì xià yùn xíng , zé ARITHABORT xuǎn xiàng bì xū shè zhì wèi ON 。
technet.microsoft.com
10.
Added a footnote to the Set Options table about how setting ANSI_WARNINGS to ON affects the ARITHABORT setting.
向Set选项表中添加了有关将ANSI_WARNINGS设置为ON会如何影响ARITHABORT设置的脚注。
xiàng Set xuǎn xiàng biǎo zhōng tiān jiā le yǒu guān jiāng ANSI_WARNINGS shè zhì wèi ON huì rú hé yǐng xiǎng ARITHABORT shè zhì de jiǎo zhù 。
technet.microsoft.com