pull_data: Pull data from SQL server via SQL query

In martinkabe/RSQLS: Package for interactive work with SQL Server

Description

This function pulls the data from SQL server via SQL query and returns data.table and data.frame object

Usage

pull_data(connectionString, sqltask, showprogress = FALSE)

Arguments

connectionString	Connection string to SQL server.
sqltask	SQL query for selecting data on SQL server.
showprogress	Showing progress (default value is set to FALSE).

Value

Returns data.frame and data.table object.

Note

How to set up SQL Server connection string see set_connString.

Examples

## Not run: 
pull_data(connectionString, "SELECT * FROM dbo.TableName")

## End(Not run)

martinkabe/RSQLS documentation built on June 19, 2020, 8:47 a.m.