共用方式為


StoredProcedureEventSet Members

The StoredProcedureEventSet object represents a set of stored procedure events.

The following tables list the members exposed by the StoredProcedureEventSet type.

Public Constructors

  名稱 Description
StoredProcedureEventSet Overloaded. Initializes a new instance of the StoredProcedureEventSet class.

頂端

Public Properties

(see also Protected Properties )

  名稱 Description
ms220434.pubproperty(zh-tw,SQL.90).gif 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.
ms220434.pubproperty(zh-tw,SQL.90).gif 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.
ms220434.pubproperty(zh-tw,SQL.90).gif NumberOfElements Overridden. Gets the number of events in the event set.

頂端

Protected Properties

  名稱 Description
ms220434.protproperty(zh-tw,SQL.90).gif Storage  Gets or sets the bit array for event set storage. (inherited from EventSetBase)

頂端

Public Methods

(see also Protected Methods )

  名稱 Description
ms220434.pubmethod(zh-tw,SQL.90).gif Add Overloaded. Returns a set of stored procedure events after adding a new stored procedure event to the event set.
ms220434.pubmethod(zh-tw,SQL.90).gif Copy Overridden. Returns a copy of the event set.
ms220434.pubmethod(zh-tw,SQL.90).gif Equals  Overloaded. (inherited from Object )
ms220434.pubmethod(zh-tw,SQL.90).gif GetHashCode  (inherited from Object )
ms220434.pubmethod(zh-tw,SQL.90).gif GetType  (inherited from Object )
ms220434.pubmethod(zh-tw,SQL.90).gifms220434.static(zh-tw,SQL.90).gif op_Addition Creates a stored procedure event set by performing an addition operation on a StoredProcedureEvent object and a StoredProcedureEventSet object.
ms220434.pubmethod(zh-tw,SQL.90).gifms220434.static(zh-tw,SQL.90).gif op_Subtraction Creates a stored procedure event set by performing a subtraction operation on a StoredProcedureEvent object and a StoredProcedureEventSet object.
ms220434.pubmethod(zh-tw,SQL.90).gifms220434.static(zh-tw,SQL.90).gif ReferenceEquals  (inherited from Object )
ms220434.pubmethod(zh-tw,SQL.90).gif Remove Removes an event from the event set.
ms220434.pubmethod(zh-tw,SQL.90).gifms220434.static(zh-tw,SQL.90).gif Subtract Returns a set of stored procedure events after subtracting a stored procedure event from the specified event set.
ms220434.pubmethod(zh-tw,SQL.90).gif ToString Overridden. Returns a string that represents the StoredProcedureEventSet object.

頂端

Protected Methods

  名稱 Description
ms220434.protmethod(zh-tw,SQL.90).gif Finalize  (inherited from Object )
ms220434.protmethod(zh-tw,SQL.90).gif FitsMask  (inherited from EventSetBase )
ms220434.protmethod(zh-tw,SQL.90).gif HasCommonBits  (inherited from EventSetBase )
ms220434.protmethod(zh-tw,SQL.90).gif MemberwiseClone  (inherited from Object )
ms220434.protmethod(zh-tw,SQL.90).gif SetValue  (inherited from EventSetBase )

頂端

請參閱

參考

StoredProcedureEventSet Class
Microsoft.SqlServer.Management.Smo Namespace

其他資源

Handling SMO Events