scripts/ss_load_data.R
In MangoTheCat/dbloadss: Load simulated datasets in SQL Server
library(odbc)
library(nycflights13)
con <- DBI::dbConnect(
odbc::odbc(),
driver = "SQL Server",
server = "localhost\\SQL17ML",
database = "ml"
)
flights$id <- 1:nrow(flights)
DBI::dbWriteTable(con, "flights", flights, overwrite = TRUE)
MangoTheCat/dbloadss documentation built on May 28, 2019, 5:33 p.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
library(odbc)
library(nycflights13)
con <- DBI::dbConnect(
odbc::odbc(),
driver = "SQL Server",
server = "localhost\\SQL17ML",
database = "ml"
)
flights$id <- 1:nrow(flights)
DBI::dbWriteTable(con, "flights", flights, overwrite = TRUE)
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.