Description Usage Arguments Details Value Examples
sqlFileExecute
returns the results of an SQL query, as a data frame
1 | sqlFileExecute(sqlFile, stringsAsFactors = TRUE, connectVar)
|
sqlFile |
String. The path to your .sql file |
stringsAsFactors |
Boolean. Will strings be converted to factors? |
connectVar |
RODBC Connection. Name of the object holding your ODBC connection. |
This function makes it convenient to develop your SQL in whatever IDE you choose, without copy/pasting code to your R script–which would make maintenance tedious.
Data frame containing the results of your SQL query executed agaist the named channel.
1 | df = sqlFileExecute(sqlFile = 'file/path/exampleQuery.sql', stringsAsFactors = FALSE)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.