The SQLServerPreResult class extends the DBIResult class, the
SQLServerResult class extends the SQLServerPreResult class,
while the SQLServerUpdateResult class extends the
SQLServerResult class. The SQLServerUpdateResult class is
created by a call to dbSendStatement as the JDBC API does not return a
ResultSet but rather an integer value for non-query statements. The
dbGetRowsAffected called on SQLServerUpdateResult returns the
value produced by the JDBC API. The SQLServerPreResult class wraps a
JDBC PreparedStatement that has yet to be executed and is necessary for
dbBind to function per the DBI spec (taking a DBIResult as an input
and returning another as output). This contrasts to the JDBC interface where
binding occurs on Statement classes and not on ResultSet classes.
# S4 method for SQLServerResult
dbIsValid(dbObj)# S4 method for SQLServerPreResult,numeric
dbFetch(res, n = -1, ...)
# S4 method for SQLServerPreResult,numeric
fetch(res, n = -1, ...)
# S4 method for SQLServerUpdateResult,numeric
fetch(res, n = -1, ...)
# S4 method for SQLServerPreResult
dbBind(res, params, ..., batch = FALSE)
# S4 method for SQLServerResult,numeric
dbFetch(res, n = -1, ...)
# S4 method for SQLServerResult,numeric
fetch(res, n = -1, block = 2048L, ...)
# S4 method for SQLServerResult
dbColumnInfo(res, ...)
# S4 method for SQLServerResult
dbClearResult(res, ...)
# S4 method for SQLServerResult
dbGetStatement(res, ...)
# S4 method for SQLServerResult
dbGetRowCount(res, ...)
# S4 method for SQLServerResult
dbGetRowsAffected(res, ...)
# S4 method for SQLServerUpdateResult
dbGetRowsAffected(res, ...)
# S4 method for SQLServerResult
dbHasCompleted(res, ...)
# S4 method for SQLServerUpdateResult
dbHasCompleted(res, ...)
logical, indicates whether uploads (e.g., 'INSERT' or
'UPDATE') should be uploaded in batches, potentially much faster
than by individual rows (the default). (Setting it here enabled
binding the variables in batches, the actual batched upload is
done in dbSendStatement or
dbExecute.)