Clase StoredProcedureEventSet
The StoredProcedureEventSet object represents a set of stored procedure events.
Jerarquía de herencia
System.Object
Microsoft.SqlServer.Management.Smo.EventSetBase
Microsoft.SqlServer.Management.Smo.StoredProcedureEventSet
Espacio de nombres: Microsoft.SqlServer.Management.Smo
Ensamblado: Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Sintaxis
'Declaración
Public NotInheritable Class StoredProcedureEventSet _
Inherits EventSetBase
'Uso
Dim instance As StoredProcedureEventSet
public sealed class StoredProcedureEventSet : EventSetBase
public ref class StoredProcedureEventSet sealed : public EventSetBase
[<SealedAttribute>]
type StoredProcedureEventSet =
class
inherit EventSetBase
end
public final class StoredProcedureEventSet extends EventSetBase
El tipo StoredProcedureEventSet expone los siguientes miembros.
Constructores
Nombre | Descripción | |
---|---|---|
StoredProcedureEventSet() | Initializes a new instance of the StoredProcedureEventSet class. | |
StoredProcedureEventSet(StoredProcedureEvent) | Initializes a new instance of the StoredProcedureEventSet class with a specified event. | |
StoredProcedureEventSet(array<StoredProcedureEvent[]) | Initializes a new instance of the StoredProcedureEventSet class with a specified set of events. | |
StoredProcedureEventSet(StoredProcedureEventSet) | Initializes a new instance of the StoredProcedureEventSet class with a specified set of events. |
Arriba
Propiedades
Nombre | Descripción | |
---|---|---|
AlterProcedure | Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a stored procedure is altered. | |
DropProcedure | Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a stored procedure is dropped. | |
NumberOfElements | Gets the number of events in the event set. (Invalida EventSetBase.NumberOfElements.) | |
Storage | Gets or sets the bit array for event set storage. (Se hereda de EventSetBase.) |
Arriba
Métodos
Nombre | Descripción | |
---|---|---|
Add(StoredProcedureEvent) | Returns a set of stored procedure events after adding a new stored procedure event to the referenced event set. | |
Add(StoredProcedureEventSet, StoredProcedureEvent) | Returns a set of stored procedure events after adding a new stored procedure event to the specified event set. | |
Copy | Returns a copy of the event set. (Invalida EventSetBase.Copy().) | |
Equals | (Se hereda de Object.) | |
GetHashCode | (Se hereda de Object.) | |
GetType | (Se hereda de Object.) | |
Remove | Removes an event from the event set. | |
Subtract | Returns a set of stored procedure events after subtracting a stored procedure event from the specified event set. | |
ToString | Returns a string that represents the StoredProcedureEventSet object. (Invalida Object.ToString().) |
Arriba
Operadores
Nombre | Descripción | |
---|---|---|
Addition | Creates a stored procedure event set by performing an addition operation on a StoredProcedureEvent object and a StoredProcedureEventSet object. | |
Subtraction | Creates a stored procedure event set by performing a subtraction operation on a StoredProcedureEvent object and a StoredProcedureEventSet object. |
Arriba
Comentarios
SQL Server provides events subscriptions for all SMO objects that have server event support. The StoredProcedure object has event support for the events that are represented by StoredProcedureEventSet properties.
Thread Safety
Todos los miembros estáticos (compartidos en Microsoft Visual Basic) públicos de este tipo son seguros para operaciones multiproceso. No se garantiza que los miembros de instancia sean seguros para subprocesos.
Ejemplos
Seguridad para subprocesos
Cualquier miembro público static (Shared en Visual Basic) de este tipo es seguro para subprocesos. No se garantiza que los miembros de instancia sean seguros para subprocesos.