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)