SQLServerConnection-class: SQL Server Connection class

In imanuelcostigan/RSQLServer: SQL Server R Database Interface (DBI) and 'dplyr' SQL Backend

Description

SQL Server Connection class

Usage

## S4 method for signature 'SQLServerConnection'
dbGetInfo(dbObj, ...)

## S4 method for signature 'SQLServerConnection'
dbIsValid(dbObj, ...)

## S4 method for signature 'SQLServerConnection'
dbDisconnect(conn, ...)

## S4 method for signature 'SQLServerConnection,character'
dbSendQuery(conn, statement,
  params = NULL, ..., batch = FALSE)

## S4 method for signature 'SQLServerConnection,character'
dbSendStatement(conn, statement,
  params = NULL, ..., batch = FALSE)

dbSendUpdate(conn, statement, ...)

## S4 method for signature 'SQLServerConnection,character'
dbReadTable(conn, name, ...)

## S4 method for signature 'SQLServerConnection'
dbDataType(dbObj, obj, ...)

## S4 method for signature 'SQLServerConnection'
dbListTables(conn, pattern = "%", ...)

## S4 method for signature 'SQLServerConnection'
dbExistsTable(conn, name, ...)

## S4 method for signature 'SQLServerConnection'
dbRemoveTable(conn, name, ...)

## S4 method for signature 'SQLServerConnection'
dbBegin(conn, ...)

## S4 method for signature 'SQLServerConnection'
dbCommit(conn, ...)

## S4 method for signature 'SQLServerConnection'
dbRollback(conn, ...)

## S4 method for signature 'SQLServerConnection'
dbWriteTable(conn, name, value,
  row.names = NA, overwrite = FALSE, append = FALSE, field.types = NULL,
  temporary = FALSE, batch = FALSE)

## S4 method for signature 'SQLServerConnection'
sqlCreateTable(con, table, fields,
  row.names = NA, temporary = FALSE, ...)

Arguments

batch

logical, indicates whether uploads (e.g., 'INSERT' or 'UPDATE') should be uploaded in batches, potentially much faster than by individual rows (the default).

imanuelcostigan/RSQLServer documentation built on May 18, 2019, 3:44 a.m.