共用方式為


Mode Element (XMLA)

Identifies the mode to be used by the parent Lock element when creating a lock on a specified object.

語法

<Lock>
   ...
   <Mode>...</Mode>
   ...
</Lock>

Element Characteristics

Characteristic Description

Data type and length

String (enumeration)

Default value

None

Cardinality

1-1: Required element that occurs once and only once.

Element Relationships

Relationship Element

Parent elements

Lock, Unlock

Child elements

None

備註

The parent Lock element uses the Mode element to determine the type of lock to create on an object. The value of this element is limited to one of the strings listed in the following table.

Value Description

CommitShared

A shared lock is established on the specified object. Other shared locks can be created for the same object.

A shared lock prevents transactions containing write operations, such as an Execute method call running an Alter command, on a specified object, from committing until the shared lock is removed. A shared lock does not prevent transactions containing read operations, such as a Discover method call or an Execute method call running a Statement command, from committing.

CommitExclusive

An exclusive lock is established on the specified object. Other shared or exclusive locks cannot be created for the same object.

An exclusive lock prevents transactions containing either read or write operations on a specified object from committing until the exclusive lock is removed.

請參閱

參考

ID Element (XMLA)
Object Element (XMLA)

概念

Properties (XMLA)

說明及資訊

取得 SQL Server 2005 協助