Metodo StoredProcedure.Script (ScriptingOptions)

Generates a Transact-SQL script that can be used to re-create the stored procedure as specified by the script options.

Spazio dei nomi  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Sintassi

'Dichiarazione
Public Function Script ( _
    scriptingOptions As ScriptingOptions _
) As StringCollection
'Utilizzo
Dim instance As StoredProcedure 
Dim scriptingOptions As ScriptingOptions 
Dim returnValue As StringCollection 

returnValue = instance.Script(scriptingOptions)
public StringCollection Script(
    ScriptingOptions scriptingOptions
)
public:
virtual StringCollection^ Script(
    ScriptingOptions^ scriptingOptions
) sealed
abstract Script : 
        scriptingOptions:ScriptingOptions -> StringCollection  
override Script : 
        scriptingOptions:ScriptingOptions -> StringCollection
public final function Script(
    scriptingOptions : ScriptingOptions
) : StringCollection

Parametri

Valore restituito

Tipo: System.Collections.Specialized.StringCollection
A StringCollection system object value that contains a list of Transact-SQL statements in the script.

Implementa

IScriptable.Script(ScriptingOptions)

Osservazioni

[!NOTA]

Lo script generato potrebbe contenere procedure interne non documentate, necessarie per generare l'output completo dello script.

Esempi

Generazione di script

Vedere anche

Riferimento

StoredProcedure Classe

Overload Script

Spazio dei nomi Microsoft.SqlServer.Management.Smo

Altre risorse

CREATE PROCEDURE (Transact-SQL)