Description Usage Arguments Value Note Examples
This function pulls the data from SQL server directly into flat file via StreamReader class via SQL query and returns data.table and data.frame object.
1 | dpull_data(connectionString, sqltask, showprogress = FALSE)
|
connectionString |
Connection string to SQL server. |
sqltask |
SQL query for selecting data on SQL server. |
showprogress |
Showing progress (default value is FALSE). |
Returns data.frame and data.table object.
How to set up SQL Server connection string see set_connString.
1 2 3 4 | ## Not run:
dpull_data(connectionString, "SELECT * FROM dbo.TableName")
## End(Not run)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.