package: RSQLS package

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

Description

Package for interactive work with SQL Server.

push_data

Pushing data into SQL Server.

pull_data

Pulling data from SQL Server into StringBuilder and then into flat file.

dpull_data

Pulling data from SQL Server directly into flat file via StreamReader class.

send_SQL_task

Allows user to create table, drop table, delere rows in table or create new table on SQL Server.

get_DB_info

Retrieving basic info about SQL database.

get_table_info

Retrieving basic info about SQL table.

Usage

push_data(connectionString, DataFrame, "dbo.TableName", append = F, showprogress = F)
pull_data(connectionString, "SELECT * FROM dbo.TableName")
dpull_data(connectionString, "SELECT * FROM dbo.TableName")
send_SQL_task(connectionString, "CREATE TABLE dbo.TableName (ID int not null, Name varchar(100))")
send_SQL_task(connectionString, "DELETE FROM dbo.TableName WHERE ColumnName = 'SomeValue'")
send_SQL_task(connectionString, "DROP TABLE dbo.TableName")
get_DB_info(connectionString)
get_table_info(connectionString, "dbo.tableName")

Note

How to set up SQL Server connection string see set_connString.

Author(s)

Martin Kovarik

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