Sometimes , the term update refers to any data modification , including insert , update , and delete operations . update lock 第二个任务在锁定该表之前不必检查各个页锁或行锁,而只需检查该表的意向锁。
Specifies the data modification statements that activate the dml trigger when it is tried against this table or view 指定数据修改语句,这些语句可在dml触发器对此表或视图进行尝试时激活该触发器。
Earlier versions of sql server only support after triggers defined on the insert and other data modification statements Sql server的早期版本只支持在insert和其他数据修改语句上定义的after触发器。
A subscription to a transactional publication for which the user is able to make data modifications at the subscriber 它使用分配的优先级值来检测和解决冲突。在sql server的早期版本中称为全局订阅。
A cursor that does not reflect data modification made to the underlying data by other users while the cursor is open 修改一个或多个现有行中的一个或多个数据值的操作,通常使用update语句来执行该操作。
When data modifications are made at the publisher , the individual transactions are captured and propagated to subscribers 在发布服务器中进行数据修改时,便会捕获各个事务并将这些事务传播到订阅服务器。
Specifies whether underlying tables and associated indexes are available for queries and data modification during the index operation 指定在索引操作期间基础表和关联的索引是否可用于查询和数据修改操作。
All data modifications made to that point in the current transaction are rolled back , including any that were made by the trigger 当前事务中该时间点之前所做的所有数据修改都将回滚,包括触发器所做的修改。
A transaction must be an atomic unit of work ; either all of its data modifications are performed , or none of them is performed 原子性事务必须是原子工作单元;对于其数据修改,要么全都执行,要么全都不执行。
The frequency of checkpoints in each database depends on the amount of data modifications made , not on any time - based measure 每一个数据库的检查点发生频率取决于数据更改的数量,而不是以时间为基础的方式来确定。