IDbStoredProcedureManager.GetStoredProcedureCreateFromExistingStatement Method

Article
05/02/2012

Returns the CREATE PROCEDURE definition for a new stored procedure that is based on an existing stored procedure.

Namespace: Microsoft.Web.Management.DatabaseManager
Assembly: Microsoft.Web.Management.DatabaseManager (in Microsoft.Web.Management.DatabaseManager.dll)

Syntax

'Declaration
Function GetStoredProcedureCreateFromExistingStatement ( _
    connectionString As String, _
    schema As String, _
    storedProcedureName As String _
) As Query
'Usage
Dim instance As IDbStoredProcedureManager
Dim connectionString As String
Dim schema As String
Dim storedProcedureName As String
Dim returnValue As Query

returnValue = instance.GetStoredProcedureCreateFromExistingStatement(connectionString, _
    schema, storedProcedureName)

Query GetStoredProcedureCreateFromExistingStatement(
    string connectionString,
    string schema,
    string storedProcedureName
)

Query^ GetStoredProcedureCreateFromExistingStatement(
    String^ connectionString, 
    String^ schema, 
    String^ storedProcedureName
)

function GetStoredProcedureCreateFromExistingStatement(
    connectionString : String, 
    schema : String, 
    storedProcedureName : String
) : Query

Parameters

connectionString
Type: System.String
The connection string for the database.

schema
Type: System.String

storedProcedureName
Type: System.String
The name of the existing stored procedure.

Return Value

Type: Microsoft.Web.Management.DatabaseManager.Query
A Query object that contains the CREATE PROCEDURE definition for a new stored procedure.

Remarks

All database providers that implement the IDbStoredProcedureManager interface must also implement the GetStoredProcedureCreateFromExistingStatement method, which returns a Query object that contains the CREATE PROCEDURE statement for your database provider, and uses an existing stored procedure as a template.

Notes for Implementers

If your provider does not support creating stored procedures, you can use the following code sample to raise a not-implemented exception:

public Query GetStoredProcedureCreateFromExistingStatement(string connectionString, string schema, string storedProcedureName)

{

throw new NotImplementedException();

}

Note

See the CREATE PROCEDURE (Transact-SQL) topic for more information about the CREATE PROCEDURE SQL statement.

Permissions

Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.

Share via