Trigger.InsertOrder Property

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

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 InsertOrder As ActivationOrder 
    Get 
    Set
'Usage
Dim instance As Trigger 
Dim value As ActivationOrder 

value = instance.InsertOrder

instance.InsertOrder = value

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

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

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

function get InsertOrder () : ActivationOrder 
function set InsertOrder (value : 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 inserted.

Examples

Creating, Altering, and Removing Triggers

See Also

Reference

Trigger Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

DML Triggers

CREATE TRIGGER (Transact-SQL)