Classe StoredProcedureEventSet
The StoredProcedureEventSet object represents a set of stored procedure events.
Gerarchia di ereditarietà
System. . :: . .Object
Microsoft.SqlServer.Management.Smo. . :: . .EventSetBase
Microsoft.SqlServer.Management.Smo..::..StoredProcedureEventSet
Spazio dei nomi Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Sintassi
'Dichiarazione
Public NotInheritable Class StoredProcedureEventSet _
Inherits EventSetBase
'Utilizzo
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
Nel tipo StoredProcedureEventSet sono esposti i membri seguenti.
Costruttori
Nome | Descrizione | |
---|---|---|
![]() |
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. |
In alto
Proprietà
Nome | Descrizione | |
---|---|---|
![]() |
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. Esegue l'override di EventSetBase. . :: . .NumberOfElements. |
![]() |
Storage | Gets or sets the bit array for event set storage. Ereditato da EventSetBase. |
In alto
Metodi
Nome | Descrizione | |
---|---|---|
![]() |
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. Esegue l'override di EventSetBase. . :: . .Copy() () () (). |
![]() |
Equals | Ereditato da Object. |
![]() |
Finalize | Ereditato da Object. |
![]() |
FitsMask | Specifies whether the EventSetBase object fits the specified mask. Ereditato da EventSetBase. |
![]() |
GetHashCode | Ereditato da Object. |
![]() |
GetType | Ereditato da Object. |
![]() |
HasCommonBits | Specifies whether the EventSetBase object has common bits with another specified EventSetBase object. Ereditato da EventSetBase. |
![]() |
MemberwiseClone | Ereditato da Object. |
![]() |
Remove | Removes an event from the event set. |
![]() |
SetValue | Sets the bit value at the specified index position. Ereditato da EventSetBase. |
![]() ![]() |
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. Esegue l'override di Object. . :: . .ToString() () () (). |
In alto
Operatori
Nome | Descrizione | |
---|---|---|
![]() ![]() |
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. |
In alto
Osservazioni
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
Tutti i membri statici pubblici (Shared in Microsoft Visual Basic) di questo tipo sono sicuri per le operazioni a thread multipli. Non è invece garantita la sicurezza dei membri dell'istanza.
Protezione dei thread
I membri static (Shared in Visual Basic) pubblici di questo tipo sono affidabili. Non è invece garantita la sicurezza dei membri dell'istanza.