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;")

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


cn %>% dbDisconnect()

What about with a parameter for the stored procedure?

You can add the parameter to the Query string like:

foo <- cn %>% dbGetQuery("EXEC [dbo].[MyProcedure] @MyParam = 'bar'")