SQLServerConnection-class: SQL Server Connection class

In 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).

RSQLServer documentation built on June 20, 2017, 9:12 a.m.