Trigger.Update-Eigenschaft
Gets or sets the Boolean property value that specifies whether the trigger is fired when records are updated in the table.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase Or SfcPropertyFlags.Design)> _
Public Property Update As Boolean
Get
Set
'Usage
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)
Eigenschaftswert
Typ: 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.
Beispiele
Erstellen, Ändern und Löschen von Trigger
Siehe auch
Verweis
Microsoft.SqlServer.Management.Smo-Namespace