intersect

intersect.tbl_sqlserver

setdiff

setdiff.tbl_sqlserver

setops

x, y

If <code>x</code> and <code>y</code> are not from the same data source,
and <code>copy</code> is <code>TRUE</code>, then <code>y</code> will be copied into the
same src as <code>x</code>.  This allows you to join tables across srcs, but
it is a potentially expensive operation so you must opt into it.

copy


Customised intersect and setdiff methods for the dplyr generics (which
override base package function definitions). These methods
only support SQL Server 2005 and greater.


Utilises The jTDS Project's JDBC 3.0 SQL Server
driver to extend the RJDBC classes and DBI methods. It defines a
SQLServerDriver, SQLServerConnection & SQLServerRsult S4 classes as
extensions of the RJDBC equivalent classes with most DBI
methods being thin extensions of the methods defined by RJDBC classes.
However, the dbConnect interface is more convenient, and the data reading
and writing capabilities found in RJDBC's fetch and dbWriteTable methods
have been refined. The package also implements a SQL backend to the dplyr
package.

setops: Intersect and setdiff methods

Description

Usage

Arguments

See Also