共用方式為


Trigger.InsteadOf 屬性

Gets or sets a Boolean property that specifies whether the trigger runs instead of the insert, delete, or update operation.

命名空間:  Microsoft.SqlServer.Management.Smo
組件:  Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase Or SfcPropertyFlags.Design)> _
Public Property InsteadOf As Boolean 
    Get 
    Set
'用途
Dim instance As Trigger 
Dim value As Boolean 

value = instance.InsteadOf

instance.InsteadOf = value
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)]
public bool InsteadOf { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase|SfcPropertyFlags::Design)]
public:
property bool InsteadOf {
    bool get ();
    void set (bool value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)>]
member InsteadOf : bool with get, set
function get InsteadOf () : boolean 
function set InsteadOf (value : boolean)

屬性值

型別:System.Boolean
A Boolean value that specifies whether the trigger is executed instead of the insert, delete, or update operation.If True, the trigger is executed instead of the insert, delete, or update operation.If False (default), the trigger is executed as well as the insert, delete, or update operation.

範例

建立、改變和移除觸發程式

請參閱

參考

Trigger 類別

Microsoft.SqlServer.Management.Smo 命名空間

其他資源

DML 觸發程序

CREATE TRIGGER (Transact-SQL)