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)