delete statement 中文意思是什麼
delete statement
解釋
刪除敘述-
Although a truncate table statement is, in effect, a delete without a where clause because it removes all rows ; it is not logged and therefore cannot execute a trigger
躍然truncate table語句實際上就是不含where子句的delete語句(因為它刪除所有行) ,但它是無日誌記錄的,因而不能執行觸發器。 -
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語句使用鎖定方法。 -
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 。 -
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值。 -
If you have to use top to delete rows in a meaningful chronological order, you must use top together with order by in a subselect statement
如果需要使用top來刪除按有意義的時間順序排列的行,您必須同時使用top和order by子句。 -
The delete statement is provided all primary key column values
為delete語句提供所有主鍵列值。 -
Property to a sql statement used to delete data
屬性設置為用來刪除數據的sql語句。 -
The after trigger operation checks for the effects of the triggering statement and also all referential cascade update and delete actions that are caused by the triggering statement
After觸發器操作要檢查觸發語句的效果,也包括所有由觸發語句引起的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語句修改的表的索引包含在脫機文件組中,這些語句將失敗。 -
A recursive cte can greatly simplify the code required to run a recursive query within a select, insert, update, delete, or create view statement
遞歸cte可以極大地簡化在select 、 insert 、 update 、 delete或create view語句中運行遞歸查詢所需的代碼。 -
You can use the top clause to limit the number of rows that are deleted in a delete statement
可以使用top子句限制delete語句中刪除的行數。 -
And that is what the delete statement is doing
而這就是delete語句所進行的工作。 -
If a delete statement is executed on a row in the
表中的行執行delete語句,並且為 -
The delete statement takes one of the following forms
語句可以使用下面形式中的一種: -
The delete statement is used to delete rows in a table
Delete聲明常用來刪除表中的數據。 -
Data was changed by a delete statement
數據已由delete語句更改。 -
Observe the delete statement that has replaced the drop statement
請觀察取代drop語句的delete語句。
分享友人