set overflow 中文意思是什麼
set overflow
解釋
溢出位置一-
In a virtual - memory system, programs are given access to a larger set of addresses than is physically available, and a dedicated memory manager maps these logical addresses to actual locations, using temporary storage on disc to hold the overflow
在虛擬內存系統中,程序可以訪問超出可用物理內存的更大的地址集合,專用內存管理程序將這些邏輯地址映射到實際地址,使用磁盤上的臨時存儲保存超出的部分。 -
If arithabort is set to on, the query fails with an arithmetic overflow error
;並且arithabort設置為on ,則查詢將因算術溢出錯誤而失敗。 -
When set to off, the divide - by - zero and arithmetic overflow errors cause null values to be returned
設置為off時,被零除錯誤和算術溢出錯誤將導致返回空值。如果在 -
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 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 。 -
When an insert 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 to on
如果在表達式計算過程中insert語句遇到算術錯誤(溢出、被零除或域錯誤) ,則數據庫引擎會處理這些錯誤,就好像set arithabort設置為on一樣。 -
During expression evaluation when set arithabort is off, if an insert, delete or update statement encounters an arithmetic error, overflow, divide - by - zero, or a domain error, sql server inserts or updates a null value
如果set arithabort為off ,並且在對表達式求值的過程中insert 、 delete或update語句遇到算術錯誤(溢出、被零除或域錯誤) , sql server將插入或更新一個null值。 -
While floating - point data is stored in the fprs in double - precision format, a set of single - precision arithmetic instructions perform the arithmetic operation and round the final result to single - precision while detecting exceptions such as exponent overflow, underflow, and inexact that should occur with a single - precision operation
雖然浮點數以雙精度格式存儲于fpr中,但是,有一組單精度運算指令,可以執行運算操作並將最終結果舍入為單精度,同時檢測進行單精度操作時可能會發生的異常(比如指數溢出、下溢和失去精度) 。 -
The following example demonstrates the divide - by - zero and overflow errors that have both set arithabort settings
設置下的被零除錯誤和溢出錯誤。
分享友人