Trigger.UpdateOrder Property

  • Article

 

Applies To: SQL Server 2016 Preview

Gets or sets the order in which the trigger and the update operation are executed.

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

[SfcPropertyAttribute(SfcPropertyFlags.None | SfcPropertyFlags.Standalone | SfcPropertyFlags.SqlAzureDatabase | SfcPropertyFlags.Design | SfcPropertyFlags.Matrix)]
public ActivationOrder UpdateOrder { get; set; }

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

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

<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase Or SfcPropertyFlags.Design Or SfcPropertyFlags.Matrix)>
Public Property UpdateOrder As ActivationOrder

Property Value

Type: Microsoft.SqlServer.Management.Smo.Agent.ActivationOrder

An ActivationOrder object value that specifies whether the trigger is executed before or after the records are updated.

Examples

Legacy Code Example

Creating, Altering, and Removing Triggers

See Also

Trigger Class
Microsoft.SqlServer.Management.Smo Namespace

CREATE TRIGGER (Transact-SQL)
Unable to find linked topic 'fface999-424a-4815-bc04-cbbd168c65ab'.

Return to top