call_function: Call a SQL function/procedure.

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

Call a SQL function/procedure.

Description

Call a SQL function/procedure.

Usage

call_function(con, schema, function_name, args, dialect = "T-SQL", cast = TRUE)

Arguments

con	A database connection.
schema	A string, the schema to query.
function_name	A string, the function/procedure to query.
args	A named list or vector, names are the parameter names and values are the parameter values.
dialect	A string, "T-SQL" or "Postgresql".,
cast	TRUE/FALSE, if TRUE, will add SQL to cast the parameters to the specified type.

Value

A data.table.

Examples

call_function(con = NULL)

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