Proprietà Trigger.InsteadOf
Gets or sets a Boolean property that specifies whether the trigger runs instead of the insert, delete, or update operation.
Spazio dei nomi Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Sintassi
'Dichiarazione
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase Or SfcPropertyFlags.Design)> _
Public Property InsteadOf As Boolean
Get
Set
'Utilizzo
Dim instance As Trigger
Dim value As Boolean
value = instance.InsteadOf
instance.InsteadOf = value
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)]
public bool InsteadOf { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase|SfcPropertyFlags::Design)]
public:
property bool InsteadOf {
bool get ();
void set (bool value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)>]
member InsteadOf : bool with get, set
function get InsteadOf () : boolean
function set InsteadOf (value : boolean)
Valore proprietà
Tipo: System.Boolean
A Boolean value that specifies whether the trigger is executed instead of the insert, delete, or update operation.If True, the trigger is executed instead of the insert, delete, or update operation.If False (default), the trigger is executed as well as the insert, delete, or update operation.
Esempi
Creazione, modifica e rimozione di trigger
Vedere anche
Riferimento
Spazio dei nomi Microsoft.SqlServer.Management.Smo