t_sql_script_proc_definition {sqlHelpers}

Fetch the object definition of a proc in Microsoft SQL Server.

Description

Fetch the object definition of a proc in Microsoft SQL Server.

Usage

t_sql_script_proc_definition(con, proc)

Arguments

con

A database connection that can be passed to DBI::dbSendQuery/DBI::dbGetQuery.

proc

A string, the database and schema qualified table name of an existing SQL stored procedure.

Value

A string, contains the script for defining a stored procedure.

Examples

t_sql_script_proc_definition(con = NULL)