共用方式為


Trigger.Insert 屬性

Gets or sets the Boolean property value that specifies whether the trigger is fired when records are inserted into 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 Insert As Boolean 
    Get 
    Set
'用途
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)

屬性值

型別: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.

範例

建立、改變和移除觸發程式

請參閱

參考

Trigger 類別

Microsoft.SqlServer.Management.Smo 命名空間

其他資源

DML 觸發程序

CREATE TRIGGER (Transact-SQL)