RODBC and sqlQueries with R objects

Question

I got a special problem I try to standadize SQL queries since they come up several times in my file.

An example.

at the top I want to define the column name and the table

Testquery <- c("COLUMN1")
Testtanle <- c("TABLE1")

Down the road in my code I want this to be implemented in a SQL query

Newvector<-sqlQuery(channel, "SELECT" Testquery "FROM" Testtanle)

Of course I run into problems with the "". Anyone an Idea how to handle this?

Thanks in advance

are you looking for the paste() command or do you mean something else? — Stephen Henderson
– Stephen Henderson, Commented Nov 27, 2013 at 14:57

Stephen Henderson · Accepted Answer · 2013-11-27 14:59:56Z

2

I think this is what you are asking?

Newvector<-sqlQuery(channel, paste("SELECT", Testquery, "FROM", Testtanle))

answered Nov 27, 2013 at 14:59

Stephen Henderson

6,5424 gold badges30 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1