ExecuteQuery: Execute a sql query on the database
In bfatemi/sqlsauce: The Secret Sauce for Dishing Data
Description
Usage
Arguments
Value
Description
This function is a wrapper around RODBC::sqlQuery that provides some convenience as it interacts with the
connection handlers in this package. Additionally, it provides helpful errors, a tracing system, and various other checks
Usage
1
Arguments
db
A database to send a query to and retrieve data from
query
A valid SQL query string
time
A boolean indicating wether to display the query's time to completion
Value
A data.table with query results
bfatemi/sqlsauce documentation built on May 12, 2019, 7:27 p.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Description Usage Arguments Value
Description
This function is a wrapper around RODBC::sqlQuery that provides some convenience as it interacts with the
connection handlers in this package. Additionally, it provides helpful errors, a tracing system, and various other checks
Usage
1 |
Arguments
db |
A database to send a query to and retrieve data from |
query |
A valid SQL query string |
time |
A boolean indicating wether to display the query's time to completion |
Value
A data.table with query results
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.