Bagikan melalui


StoredProcedure.AssemblyName Property

Gets or sets the name of the .NET assembly that is required by the referenced stored procedure.

This API is not CLS-compliant. 

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
<SfcReferenceAttribute(GetType(SqlAssembly), "Server[@Name = '{0}']/Database[@Name = '{1}']/SqlAssembly[@Name = '{2}']",  _
    )> _
<CLSCompliantAttribute(False)> _
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.Design)> _
Public Property AssemblyName As String 
    Get 
    Set
'Usage
Dim instance As StoredProcedure 
Dim value As String 

value = instance.AssemblyName

instance.AssemblyName = value
[SfcReferenceAttribute(typeof(SqlAssembly), "Server[@Name = '{0}']/Database[@Name = '{1}']/SqlAssembly[@Name = '{2}']", 
    )]
[CLSCompliantAttribute(false)]
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.Design)]
public string AssemblyName { get; set; }
[SfcReferenceAttribute(typeof(SqlAssembly), L"Server[@Name = '{0}']/Database[@Name = '{1}']/SqlAssembly[@Name = '{2}']", 
    )]
[CLSCompliantAttribute(false)]
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::Design)]
public:
property String^ AssemblyName {
    String^ get ();
    void set (String^ value);
}
[<SfcReferenceAttribute(typeof(SqlAssembly), "Server[@Name = '{0}']/Database[@Name = '{1}']/SqlAssembly[@Name = '{2}']", 
    )>]
[<CLSCompliantAttribute(false)>]
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.Design)>]
member AssemblyName : string with get, set
function get AssemblyName () : String 
function set AssemblyName (value : String)

Property Value

Type: System.String
A String value that specifies the name of the assembly that is required by the referenced stored procedure.

Remarks

A value is required for the AssemblyName property only when the ImplementationType property is set to SqlClr.

Examples

Creating, Altering, and Removing Stored Procedures

See Also

Reference

StoredProcedure Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

CREATE PROCEDURE (Transact-SQL)