SqlTriggerAttribute Class
.NET Framework 3.0
Used to mark a method definition in an assembly as a trigger in SQL Server. The properties on the attribute reflect the physical attributes used when the type is registered with SQL Server. This class cannot be inherited.
Namespace: Microsoft.SqlServer.Server
Assembly: System.Data (in system.data.dll)
Assembly: System.Data (in system.data.dll)
'Declaration <SerializableAttribute> _ <AttributeUsageAttribute(AttributeTargets.Method, AllowMultiple:=False, Inherited:=False)> _ Public NotInheritable Class SqlTriggerAttribute Inherits Attribute 'Usage Dim instance As SqlTriggerAttribute
/** @attribute SerializableAttribute() */ /** @attribute AttributeUsageAttribute(AttributeTargets.Method, AllowMultiple=false, Inherited=false) */ public final class SqlTriggerAttribute extends Attribute
SerializableAttribute AttributeUsageAttribute(AttributeTargets.Method, AllowMultiple=false, Inherited=false) public final class SqlTriggerAttribute extends Attribute
Not applicable.
The following example shows the SqlTriggerAttribute specifying the name of the trigger, the target table, and the event that will fire the trigger. See SqlTriggerContext for the full trigger example.
<SqlTrigger(Name:="SalesAudit", Target:="[dbo].[SalesInfo]", Event:="FOR INSERT")> _ Public Shared Sub SalesAudit() Dim triggContext As SqlTriggerContext ' Get the trigger context. triggContext = SqlContext.TriggerContext Select Case triggContext.TriggerAction Case TriggerAction.Insert ' Do something in response to the INSERT. End Select End Sub
Windows 98, Windows Server 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
The Microsoft .NET Framework 3.0 is supported on Windows Vista, Microsoft Windows XP SP2, and Windows Server 2003 SP1.Community Additions
ADD
Show: