StoredProcedureParameterCollection Members
The StoredProcedureParameterCollection class represents a collection of StoredProcedureParameter objects that represent all the stored procedure parameters defined on a table.
The following tables list the members exposed by the StoredProcedureParameterCollection type.
Protected Fields
| 이름 | Description | |
|---|---|---|
.gif "ms220450.protfield(ko-kr,SQL.90).gif") |
initialized | This value supports the SQL Server Management Objects infrastructure and is not intended to be used directly from your code. (inherited from AbstractCollectionBase) |
위쪽
Public Properties
| 이름 | Description | |
|---|---|---|
.gif "ms220450.pubproperty(ko-kr,SQL.90).gif") |
Count | Gets the number of objects in the referenced collection. (inherited from SmoCollectionBase) |
|
IsSynchronized | Gets the Boolean property value that specifies whether access to the collection is synchronized and therefore thread-safe. (inherited from SmoCollectionBase) |
|
Item | Overloaded. Gets a StoredProcedureParameter object in the collection by name or by index number. |
|
Parent | Gets the StoredProcedure object that is the parent of the StoredProcedureParameter object. |
|
SyncRoot | Gets an object that can be used to synchronize access to the collection. (inherited from SmoCollectionBase) |
위쪽
Public Methods
(see also Protected Methods )
| 이름 | Description | |
|---|---|---|
.gif "ms220450.pubmethod(ko-kr,SQL.90).gif") |
Add | Overloaded. Adds a StoredProcedureParameter object to the StoredProcedureParameterCollection object. |
|
Contains | (inherited from ParameterCollectionBase ) |
|
CopyTo | Copies the collection objects to a one-dimensional array beginning at the index value specified. |
|
Equals | Overloaded. (inherited from Object ) |
|
GetEnumerator | Returns an IEnumerator interface that allows you to iterate through the objects in the collection. (inherited from SmoCollectionBase) |
|
GetHashCode | (inherited from Object ) |
|
GetType | (inherited from Object ) |
|
ItemById | Extracts a member from the StoredProcedureParameterCollection object using a system-defined, unique identifier. |
.gif "ms220450.static(ko-kr,SQL.90).gif") |
ReferenceEquals | (inherited from Object ) |
|
Refresh | Overloaded. Refreshes the referenced collection. (inherited from SmoCollectionBase) |
|
Remove | Overloaded. Removes a StoredProcedureParameter object from the StoredProcedureParameterCollection object. |
|
ToString | (inherited from Object ) |
위쪽
Protected Methods
| 이름 | Description | |
|---|---|---|
.gif "ms220450.protmethod(ko-kr,SQL.90).gif") |
AddExisting | (inherited from AbstractCollectionBase ) |
|
AddImpl | (inherited from ArrayListCollectionBase ) |
|
Finalize | (inherited from Object ) |
|
GetCollectionElementType | Returns the type of object that the collection consists of. (inherited from SmoCollectionBase) |
|
GetItemById | Overloaded. (inherited from SmoCollectionBase ) |
|
GetObjectByIndex | (inherited from SmoCollectionBase ) |
|
ImplAddExisting | (inherited from ParameterCollectionBase ) |
|
InitializeChildCollection | Overloaded. Initializes the child collections of the referenced collection. (inherited from SmoCollectionBase) |
|
InitInnerCollection | Initializes the collection. (inherited from ParameterCollectionBase) |
|
MemberwiseClone | (inherited from Object ) |
|
ValidateParentObject | (inherited from SmoCollectionBase ) |
위쪽
Explicit Interface Implementations
| 이름 | Description | |
|---|---|---|
| System.Collections.ICollection.CopyTo | (inherited from SmoCollectionBase ) |
위쪽
참고 항목
참조
StoredProcedureParameterCollection Class
Microsoft.SqlServer.Management.Smo Namespace