Execute stored procedures from R with odbc and DBI

storedProcedures.R

library(tidyverse)
library(DBI)
library(odbc)


# connect to database
cn <- dbConnect(odbc::odbc(), driver = "ODBC Driver 13 for SQL Server", 
                server="MYSQLSERVER\\SQLEXPRESS", 
                database = "myTestDB",
                Trusted_Connection="Yes")

# normal query with select statement
cn %>% dbGetQuery("select * from [dbo].Tbl;")

# query a stored procedure
cn %>% dbGetQuery("EXEC [dbo].[meineProzedur]")


cn %>% dbDisconnect()