update or insert 中文意思是什麼
update or insert
解釋
有沒有辦法取到一個表最進一次-
The following actions to the table are considered changes : insert, update, delete, index rebuild or defragmentation, and database restore or attach
對表的以下操作可視為更改:插入、更新、刪除、索引重建或碎片整理以及數據庫還原或附加。 -
Counter indicates the level of maintenance on the index caused by insert, update, or delete operations on the underlying table or view
計數器指示由基礎表或視圖上的插入、更新或刪除操作所引起的索引維護級別。 -
Update the drop - down list whenever users edit or insert a record
在用戶編輯或插入記錄時更新下拉列表。 -
When you specify dates in comparisons or for input to insert or update statements, use constants that are interpreted the same way for all language settings
當指定用於比較的日期,或者指定用於insert或update語句的輸入的日期時,請使用對于所有的語言設置解釋方式都相同的常量: -
Table - valued functions can be invoked where table expressions are allowed in the from clause of select, insert, update, or delete statements
在允許表表達式的情況下,可在select 、 insert 、 update或delete語句的from子句中調用表值函數。 -
Specifies that the query optimizer use a table scan, one or more indexes, or a locking method with this table or view and for this select, insert, update, or delete statement
指定查詢優化器使用一個表掃描、一個或多個索引,或為當前表或視圖以及當前的select 、 insert 、 pdate或delete語句使用鎖定方法。 -
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操作,而這些列中的新值長度超出最大列大小,則將出現被零除錯誤和算術溢出錯誤導致返回空值的行為。 -
Insert or update operations that are based on a self - join follow the order in the from clause
基於自聯接的插入和更新操作遵循from子句中的順序。 -
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值。 -
In trigger terminology, the insert, delete, or update that causes a trigger to be fired is known as the
在觸發器術語中, insert 、 delete或者update這些使得觸發器啟動的事件被稱作 -
This is useful for situations such as issuing a select statement after an update or insert statement in order to get back refreshed records and any auto - generated values such as default or auto - increment values
這在類似下面的情況下很有用:在更新或insert語句之後發出一條select語句以取回已刷新記錄和任何自動生成的值(如默認值或自動增加的值) 。 -
If a low - privilege user tries to insert, update, or delete data through a distributed partitioned view, sql server generates the following error
如果低特權用戶嘗試通過分散式分區視圖插入、更新或刪除數據,則sql server將生成以下錯誤: -
Are binding results to a form to let the user view, insert, update, or delete records
正在將結果綁定到窗體,以便用戶查看、插入、更新或刪除記錄 -
To be used by the command builder for the corresponding insert, update, or delete command
由命令生成器用於對應的insert 、 update或delete命令的 -
This property cannot be changed after an insert, update, or delete command has been generated
當生成insert update或delete命令后,不能更改此屬性。 -
Properties after an insert, update, or delete command has been generated, you can change their settings after calling the
雖然在生成插入、更新或刪除命令后不能更改 -
Update parameters - when you update an existing record or insert a new one, the values for the columns in the changed or new record are established at run time
更新參數- -當更新現有記錄或插入新記錄時,已更改記錄或新記錄中列的值將在運行時建立。 -
Property, and executes the required insert, update, or delete statements iteratively for each row, based on the order of the indexes configured in the
屬性,并迭代執行所需的insert 、 update或delete語句。例如,由於 -
Additionally, any insert, update, or delete statement that modifies a table with any index in an offline filegroup will fail
此外,如果insert 、 update或delete語句修改的表的索引包含在脫機文件組中,這些語句將失敗。 -
Building the ideal index may give a dramatic performance boost to query performance, but there will be a negative impact whenever there are sql writes to the db2 database insert, update or delete
雖然建立理想化的索引可以顯著提高查詢性能,但是每當對db2數據庫執行sql寫操作( insert 、 update或delete )時,上述理想化的索引都會有負面的影響。
分享友人