Aracılığıyla paylaş

Trigger.Insert Property

  • Makale

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

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

Syntax

'Bildirim
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase Or SfcPropertyFlags.Design)> _
Public Property Insert As Boolean
    Get
    Set
'Kullanım
Dim instance As Trigger
Dim value As Boolean

value = instance.Insert

instance.Insert = value

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

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

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

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

Property Value

Type: System.Boolean
A Boolean value that specifies whether the trigger is executed when records are inserted .
If True, the trigger is executed when records are inserted.
If False (delete), the trigger is not executed when 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)