Pass R variable to RODBC's sqlQuery? [duplicate]

This question already has answers here:

Add a dynamic value into RMySQL getQuery [duplicate] (2 answers)

RSQLite query with user specified variable in the WHERE field [duplicate] (2 answers)

Closed 2 years ago.

Is there any way to pass a variable defined within R to the sqlQuery function within the RODBC package?

Specifically, I need to pass such a variable to either a scalar/table-valued function, a stored procedure, and/or perhaps the WHERE clause of a SELECT statement.

For example, let:

x <- 1 ## user-defined

Then,

example <- sqlQuery(myDB,"SELECT * FROM dbo.my_table_fn (x)")

Or...

example2 <- sqlQuery(myDB,"SELECT * FROM dbo.some_random_table AS foo WHERE foo.ID = x")

Or...

example3 <- sqlQuery(myDB,"EXEC dbo.my_stored_proc (x)")

Obviously, none of these work, but I'm thinking that there's something that enables this sort of functionality.

sql r rodbc

задан zx8754 11 November 2016 в 07:39

0 ответов

Другие вопросы по тегам:

sql r rodbc

Pass R variable to RODBC's sqlQuery? [duplicate]

0 ответов

Похожие вопросы: