UserDefinedFunctionParameter 類別
The UserDefinedFunctionParameter object represents a SQL Server user-defined function parameter.
繼承階層
System.Object
Microsoft.SqlServer.Management.Smo.SmoObjectBase
Microsoft.SqlServer.Management.Smo.SqlSmoObject
Microsoft.SqlServer.Management.Smo.NamedSmoObject
Microsoft.SqlServer.Management.Smo.ScriptNameObjectBase
Microsoft.SqlServer.Management.Smo.ParameterBase
Microsoft.SqlServer.Management.Smo.Parameter
Microsoft.SqlServer.Management.Smo.UserDefinedFunctionParameter
命名空間: Microsoft.SqlServer.Management.Smo
組件: Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)
語法
'宣告
<SfcElementTypeAttribute("Param")> _
Public NotInheritable Class UserDefinedFunctionParameter _
Inherits Parameter _
Implements ISfcSupportsDesignMode
'用途
Dim instance As UserDefinedFunctionParameter
[SfcElementTypeAttribute("Param")]
public sealed class UserDefinedFunctionParameter : Parameter,
ISfcSupportsDesignMode
[SfcElementTypeAttribute(L"Param")]
public ref class UserDefinedFunctionParameter sealed : public Parameter,
ISfcSupportsDesignMode
[<SealedAttribute>]
[<SfcElementTypeAttribute("Param")>]
type UserDefinedFunctionParameter =
class
inherit Parameter
interface ISfcSupportsDesignMode
end
public final class UserDefinedFunctionParameter extends Parameter implements ISfcSupportsDesignMode
UserDefinedFunctionParameter 型別公開下列成員。
建構函式
名稱 | 說明 | |
---|---|---|
UserDefinedFunctionParameter() | Initializes a new instance of the UserDefinedFunctionParameter class. | |
UserDefinedFunctionParameter(UserDefinedFunction, String) | Initializes a new instance of the UserDefinedFunctionParameter class for the specified user-defined function and with the specified name. | |
UserDefinedFunctionParameter(UserDefinedFunction, String, DataType) | Initializes a new instance of the UserDefinedFunctionParameter class for the specified user-defined function, with the specified name and specified data type. |
上層
屬性
名稱 | 說明 | |
---|---|---|
DataType | Gets or sets the data type associated with the parameter. (繼承自 ParameterBase。) | |
DefaultValue | Gets or sets the default value of the parameter. (繼承自 Parameter。) | |
ExtendedProperties | Represents a collection of ExtendedProperty objects. Each ExtendedProperty object represents an extended property defined on the ParameterBase object. (繼承自 ParameterBase。) | |
ID | Gets the ID value that uniquely identifies the parameter. (繼承自 Parameter。) | |
IsReadOnly | Gets or sets whether the parameter is read only. (繼承自 Parameter。) | |
Name | Gets or sets a String value that specifies the name of the parameter. (繼承自 ParameterBase。) | |
Parent | Gets the UserDefinedFunction object that is the parent of the UserDefinedFunctionParameter object. | |
Properties | Gets a collection of Property objects that represent the object properties. (繼承自 SqlSmoObject。) | |
State | Gets the state of the referenced object. (繼承自 SmoObjectBase。) | |
Urn | Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (繼承自 SqlSmoObject。) | |
UserData | Gets or sets user-defined data associated with the referenced object. (繼承自 SmoObjectBase。) |
上層
方法
名稱 | 說明 | |
---|---|---|
Discover | Discovers a list of type Object. (繼承自 SqlSmoObject。) | |
Equals | (繼承自 Object。) | |
FormatSqlVariant | Formats an object as SqlVariant type. (繼承自 SqlSmoObject。) | |
GetContextDB | Gets the context database that is associated with this object. (繼承自 SqlSmoObject。) | |
GetDBName | Gets the database name that is associated with the object. (繼承自 SqlSmoObject。) | |
GetHashCode | (繼承自 Object。) | |
GetPropValue | Gets a property value of the SqlSmoObject object. (繼承自 SqlSmoObject。) | |
GetPropValueOptional | Gets a property value of the SqlSmoObject object. (繼承自 SqlSmoObject。) | |
GetPropValueOptionalAllowNull | Gets a property value of the SqlSmoObject object. (繼承自 SqlSmoObject。) | |
GetServerObject | Gets the server of the SqlSmoObject object. (繼承自 SqlSmoObject。) | |
GetType | (繼承自 Object。) | |
Initialize() | Initializes the object and forces the properties be loaded. (繼承自 SqlSmoObject。) | |
Initialize(Boolean) | Initializes the object and forces the properties be loaded. (繼承自 SqlSmoObject。) | |
IsObjectInitialized | Verifies whether the object has been initialized. (繼承自 SqlSmoObject。) | |
IsObjectInSpace | Verifies whether the object is isolated or connected to the instance of SQL Server. (繼承自 SqlSmoObject。) | |
MarkForDrop | Marks the foreign key to be dropped next time its parent object is altered by the Alter method. (繼承自 ParameterBase。) | |
Refresh | Refreshes the ParameterBase object. (繼承自 ParameterBase。) | |
SetParentImpl | Sets the parent of the SqlSmoObject to the newParent parameter. (繼承自 SqlSmoObject。) | |
ToString | Returns a String that represents the referenced object. (繼承自 SqlSmoObject。) | |
Validate | Validates the state of an object. (繼承自 SmoObjectBase。) |
上層
事件
名稱 | 說明 | |
---|---|---|
PropertyChanged | Represents the event that occurs when a property is changed. (繼承自 SqlSmoObject。) | |
PropertyMetadataChanged | Represents the event that occurs when property metadata changes. (繼承自 SqlSmoObject。) |
上層
明確 繼承 實作
名稱 | 說明 | |
---|---|---|
IAlienObject.Discover | Discovers any dependencies. 不要直接在程式碼中參照此成員。其支援 SQL Server 基礎結構。 (繼承自 SqlSmoObject。) | |
IAlienObject.GetDomainRoot | Returns the root of the domain. (繼承自 SqlSmoObject。) | |
IAlienObject.GetParent | Gets the parent of this object. 不要直接在程式碼中參照此成員。其支援 SQL Server 基礎結構。 (繼承自 SqlSmoObject。) | |
IAlienObject.GetPropertyType | Gets the type of the specified property. (繼承自 SqlSmoObject。) | |
IAlienObject.GetPropertyValue | Gets the value of the specified property. (繼承自 SqlSmoObject。) | |
IAlienObject.GetUrn | Gets the Unified Resource Name (URN) of the object. 不要直接在程式碼中參照此成員。其支援 SQL Server 基礎結構。 (繼承自 SqlSmoObject。) | |
IAlienObject.Resolve | Gets the instance that contains the information about the object from the Unified Resource Name (URN) of the object. (繼承自 SqlSmoObject。) | |
IAlienObject.SetObjectState | Sets the object state to the specified SfcObjectState value. (繼承自 SqlSmoObject。) | |
IAlienObject.SetPropertyValue | Sets the property value. (繼承自 SqlSmoObject。) | |
ISfcPropertyProvider.GetPropertySet | Gets the interface reference to the set of properties of this object. (繼承自 SqlSmoObject。) | |
ISfcSupportsDesignMode.IsDesignMode | Gets a Boolean value that indicates whether the object supports design mode. 僅供參考之用。不支援。我們無法保證未來的相容性。 |
上層
備註
To get UserDefinedFunctionParameter object properties, users can be a member of the public fixed server role.
Thread Safety
此型別的任何公用靜態 (在 Microsoft Visual Basic 為共用) 成員具備多執行緒作業安全。並非所有的執行個體成員都是安全執行緒。
執行緒安全性
這個型別的任何公用 static (在 Visual Basic 中為 Shared) 成員都是執行緒安全的。並不是所有的執行個體成員都保證可以用於所有的執行緒。