SQLServer.Database.StoredProcedure Object
Generates a series of Transact-SQL statements (script) to create the stored procedure.
strScript = StoredProcedure.Script (
[[ScriptType :=] tScriptType,]
[[ScriptFilePath :=] strFile] )
HRESULT pStoredProcedure->Script (
SQLOLE_SCRIPT_TYPE tScriptType = SQLOLEScript_Default,
SQLOLE_LPCSTR strFile = NULL,
SQLOLE_LPBSTR pstrScript = NULL );
| Element | Type | Description |
|---|
| strScript | String | Generated Transact-SQL script |
| tScriptType | SQLOLE_SCRIPT_TYPE | Type of script to generate |
| strFile | String | Full path and file name to use to store the Transact-SQL script |