generate_stored_procedure: Generate stored procedure from SQL code and R template.

In andrie/SqlRtools: Helper functions to work with Microsoft SQL Server R Services

Description

Given two files xx.R and xx.sql, generate a stored procedure and optionally save as xx.sql

Usage

generate_stored_procedure(sp_filename_stub, dbConnection, write = FALSE)

Arguments

sp_filename_stub	File name stub for R code and SQL code, both stored as files with the same name but varying extensions.
dbConnection	Database connection string, passed to odbcDriverConnect
write	If TRUE, writes results to xx.sp.sql

andrie/SqlRtools documentation built on May 10, 2019, 11:18 a.m.