StoredProcedure.ImplementationType Property

Gets or sets the implementation type of the stored procedure.

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

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase Or SfcPropertyFlags.Design,  _
    "TransactSql")> _
Public Property ImplementationType As ImplementationType 
    Get 
    Set
'Usage
Dim instance As StoredProcedure 
Dim value As ImplementationType 

value = instance.ImplementationType

instance.ImplementationType = value

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design, 
    "TransactSql")]
public ImplementationType ImplementationType { get; set; }

[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase|SfcPropertyFlags::Design, 
    L"TransactSql")]
public:
property ImplementationType ImplementationType {
    ImplementationType get ();
    void set (ImplementationType value);
}

[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design, 
    "TransactSql")>]
member ImplementationType : ImplementationType with get, set

function get ImplementationType () : ImplementationType 
function set ImplementationType (value : ImplementationType)

Property Value

Type: Microsoft.SqlServer.Management.Smo.ImplementationType
An ImplementationType object value that specifies the implementation type of the stored procedure.

Remarks

This property specifies whether the stored procedure is implemented with a SQL Server common language runtime (CLR) type or with Transact-SQL. If the stored procedure is implemented with a SQL Server CLR type then values are required for the ExecutionContextPrincipal property, the AssemblyName property, the ClassName property, and the MethodName property.

Examples

Creating, Altering, and Removing Stored Procedures

See Also

Reference

StoredProcedure Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

CREATE PROCEDURE (Transact-SQL)