StoredProcedureEventSet 类

The StoredProcedureEventSet object represents a set of stored procedure events.

继承层次结构

System. . :: . .Object
  Microsoft.SqlServer.Management.Smo. . :: . .EventSetBase
    Microsoft.SqlServer.Management.Smo..::..StoredProcedureEventSet

命名空间：  Microsoft.SqlServer.Management.Smo
程序集：  Microsoft.SqlServer.Smo（在 Microsoft.SqlServer.Smo.dll 中）

语法

声明
Public NotInheritable Class StoredProcedureEventSet _
    Inherits EventSetBase
用法
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

StoredProcedureEventSet 类型公开以下成员。

构造函数

	名称	说明
	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.

页首

属性

	名称	说明
	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. （覆盖 EventSetBase. . :: . .NumberOfElements。）
	Storage	Gets or sets the bit array for event set storage. （从 EventSetBase 继承。）

页首

方法

	名称	说明
	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. （覆盖 EventSetBase. . :: . .Copy() () () ()。）
	Equals	（从 Object 继承。）
	Finalize	（从 Object 继承。）
	FitsMask	Specifies whether the EventSetBase object fits the specified mask. （从 EventSetBase 继承。）
	GetHashCode	（从 Object 继承。）
	GetType	（从 Object 继承。）
	HasCommonBits	Specifies whether the EventSetBase object has common bits with another specified EventSetBase object. （从 EventSetBase 继承。）
	MemberwiseClone	（从 Object 继承。）
	Remove	Removes an event from the event set.
	SetValue	Sets the bit value at the specified index position. （从 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. （覆盖 Object. . :: . .ToString() () () ()。）

页首

运算符

	名称	说明
	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.

页首

注释

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

此类型的任何公共静态（Microsoft Visual Basic 中的 Shared）成员在多线程操作中是安全的。不保证所有实例成员都是线程安全的。

示例

处理 SMO 事件

线程安全

此类型的任何公共 static（在 Visual Basic 中为 Shared） 成员都是线程安全的。不保证所有实例成员都是线程安全的。

请参阅

参考

Microsoft.SqlServer.Management.Smo 命名空间