sql: SQL Server methods for dplyr/dbplyr

Description Usage Arguments

Description

Saving tables on SQL Server with dplyr requires creating some custom methods. These are automatically called by compute, collect and copy_to.

Usage

1
2
3
4
5
6
"db_compute.Microsoft SQL Server"(con, table, sql, temporary = TRUE,
  unique_indexes = list(), indexes = list(), ...)

## S3 method for class 'Microsoft SQL Server'
db_save_query(con, sql, name, temporary = TRUE,
  ...)

Arguments

con

A DBI connection

table, name

A table name

sql

A query

temporary

Whether to generate a temporary table (which will be automatically prefixed with '##')


RevolutionAnalytics/dplyrXdf documentation built on June 3, 2019, 9:08 p.m.