send_SQL_task: Drop, delete or create table

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

Description

This function allows user to drop table, delete rows in table or create new table on SQL Server.

Usage

send_SQL_task(connectionString, sqltask)

Arguments

connectionString	Connection string to SQL server.
sqltask	SQL query for retrieving data from SQL server.

Note

How to set up SQL Server connection string see set_connString.

Examples

## Not run: 
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")

## End(Not run)

martinkabe/RSQLS_package documentation built on June 19, 2020, 2:19 p.m.