db_query: Execute SQL query from file

Description Usage Arguments Value

Description

Execute SQL query from file

Usage

1
db_query(file, query = 1, parameters = NULL, conn = NULL)

Arguments

file

filename of file containing the SQL query

query

character string referencing the SQL query in the file (in case there is more than one)

parameters

list of parameters to substitute in the SQL query

conn

RODBC connection object as returned by db_connect(). Optional, but allows to re-use an already open connection.

Value

SQL query as character string


itssimon/sqlservr documentation built on Aug. 6, 2021, 1:53 a.m.