Trigger.Update 속성

  • 아티클

Gets or sets the Boolean property value that specifies whether the trigger is fired when records are updated in the table.

네임스페이스:  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 Update As Boolean 
    Get 
    Set
‘사용 방법
Dim instance As Trigger 
Dim value As Boolean 

value = instance.Update

instance.Update = value

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)]
public bool Update { get; set; }

[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase|SfcPropertyFlags::Design)]
public:
property bool Update {
    bool get ();
    void set (bool value);
}

[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)>]
member Update : bool with get, set

function get Update () : boolean 
function set Update (value : boolean)

속성 값

유형: System.Boolean
A Boolean value that specifies whether the trigger is executed when records are updated .If True, the trigger is executed when records are updated.If False (delete), the trigger is not executed when records are updated.

예

트리거 생성, 변경 및 제거

참고 항목

참조

Trigger 클래스

Microsoft.SqlServer.Management.Smo 네임스페이스

관련 자료

DML 트리거

CREATE TRIGGER(Transact-SQL)