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

by

Build the string you intend to pass. So instead of

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

do

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

which will fill in the value of x.

More Related Contents:

  1. Dynamic “string” in R
  2. Parameterized queries with RODBC
  3. RODBC Temporary Table Issue when connecting to MS SQL Server
  4. dplyr left_join by less than, greater than condition
  5. How to emulate SQLs rank functions in R?
  6. How to read the contents of an .sql file into an R script to run a query?
  7. Pass string variable in R script to use it in SQL statement
  8. Re-Writing “Fuzzy Join” Functions from R to SQL
  9. Query to get only numbers from a string
  10. How to create a Calendar table for 100 years in Sql [closed]
  11. Oracle Differences between NVL and Coalesce
  12. Grouped LIMIT in PostgreSQL: show the first N rows for each group?
  13. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  14. SQL Server indexes – ascending or descending, what difference does it make?
  15. Identity column value suddenly jumps to 1001 in sql server [duplicate]
  16. How to capitalize the first letter of each word in a string in SQL Server
  17. How to get a list of column names on Sqlite3 database?
  18. How do I sort a VARCHAR column in SQL server that contains numbers?
  19. SQL: Select dynamic column name based on variable
  20. Why do you create a View in a database?
  21. The SQL OVER() clause – when and why is it useful?
  22. Cannot use a CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text indexed
  23. Merge overlapping date intervals
  24. How does a Recursive CTE run, line by line?
  25. SQL poor stored procedure execution plan performance – parameter sniffing
  26. Improving performance of cluster index GUID primary key
  27. SQL for ordering by number – 1,2,3,4 etc instead of 1,10,11,12
  28. Mysql strip time component from datetime
  29. How to detect query which holds the lock in Postgres?
  30. How to get the next number in a sequence

Leave a Comment