t_sql_script_proc_definition: Fetch the object definition of a proc in Microsoft SQL...

In sqlHelpers: Collection of 'SQL' Utilities for 'T-SQL' and 'Postgresql'

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)

sqlHelpers documentation built on Oct. 15, 2023, 1:07 a.m.