Sql server 2005 returns a null in a calculation involving an overflow or divide - by - zero error , regardless of this setting Sql server 2005在计算中出现溢出或被零除错误时将返回null ,不考虑此设置。
Datatips are not available for invalid expressions , such as division by zero , or expressions that involve function evaluation 数据提示功能不能用于无效的表达式(如被零除)或涉及函数计算的表达式。
Notice that the first troubleshooting tip in the exception assistant suggests that you should make sure you are not dividing by zero 注意, “异常助手”中的第一个故障排除提示建议应确保不会被零除。
When set to on , the divide - by - zero and arithmetic overflow errors cause the statement to be rolled back and an error message is generated 设置为on时,被零除错误和算术溢出错误将导致回滚语句,并生成错误消息。
When your application encounters an exceptional circumstance , such as a division by zero or low memory warning , an exception is generated 在应用程序遇到异常情况(如被零除情况或内存不足警告)时,就会产生异常。
When set ansi warnings is on , errors or warnings are raised in divide - by - zero , string too large for database column , and other similar errors 如果set ansi _ warnings为on ,则发生被零除、字符串超出数据库列及其他类似错误时,将引发错误或警告。
When an update statement encounters an arithmetic error overflow , divide by zero , or a domain error during expression evaluation , the update is not performed 当update语句在表达式求值过程中遇到算术错误(溢出、被零除或域错误)时,则不进行更新。
The behavior in which a divide - by - zero or arithmetic overflow error causes null values to be returned occurs if an insert or update is tried on a 列上尝试执行insert或update操作,而这些列中的新值长度超出最大列大小,则将出现被零除错误和算术溢出错误导致返回空值的行为。
Floating - point arithmetic overflow or division by zero never throws an exception , because floating - point types are based on ieee 754 and so have provisions for representing infinity and nan not a number 浮点算术溢出或被零除从不引发异常,因为浮点类型基于ieee 754 ,因此可以表示无穷和nan (不是数字) 。
When a delete statement encounters an arithmetic error overflow , divide by zero , or a domain error occurring during expression evaluation , the database engine handles these errors as if set arithabort is set on 当delete语句遇到在表达式计算过程中发生的算术错误(溢出、被零除或域错误)时,数据库引擎将处理这些错误,就好象set arithabort设置为on 。