Learn R
RSQLServer (version 0.3.0)

SQLServerConnection-class: SQL Server Connection class

Description

SQL Server Connection class

Usage

# S4 method for SQLServerConnection
dbGetInfo(dbObj, ...)
# S4 method for SQLServerConnection
dbIsValid(dbObj, ...)
# S4 method for SQLServerConnection
dbDisconnect(conn, ...)
# S4 method for SQLServerConnection,character
dbSendQuery(conn, statement,
  params = NULL, ..., batch = FALSE)
# S4 method for SQLServerConnection,character
dbSendStatement(conn, statement,
  params = NULL, ..., batch = FALSE)
dbSendUpdate(conn, statement, ...)
# S4 method for SQLServerConnection,character
dbReadTable(conn, name, ...)
# S4 method for SQLServerConnection
dbDataType(dbObj, obj, ...)
# S4 method for SQLServerConnection
dbListTables(conn, pattern = "%", ...)
# S4 method for SQLServerConnection
dbExistsTable(conn, name, ...)
# S4 method for SQLServerConnection
dbRemoveTable(conn, name, ...)
# S4 method for SQLServerConnection
dbBegin(conn, ...)
# S4 method for SQLServerConnection
dbCommit(conn, ...)
# S4 method for SQLServerConnection
dbRollback(conn, ...)
# S4 method for SQLServerConnection
dbWriteTable(conn, name, value,
  row.names = NA, overwrite = FALSE, append = FALSE, field.types = NULL,
  temporary = FALSE, batch = FALSE)
# S4 method for 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).