Dynamic “string” in R

by

We can use paste:

Df <- sqlQuery(ch, paste("SELECT * FROM tblTest WHERE Id =", Id))

c concatenates into a vector, paste is for string concatenation.

Or we can use sprintf:

sprintf("SELECT * FROM tblTest WHERE Id = %s", Id)

More Related Contents:

  1. Pass R variable to RODBC’s sqlQuery? [duplicate]
  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. SQL Selecting from three tables
  10. How to cast the DateTime to Time
  11. Inner join vs Where
  12. Computed / calculated / virtual / derived columns in PostgreSQL
  13. Generate a resultset of incrementing dates in TSQL
  14. Xcode 4 and Core Data: How to enable SQL Debugging
  15. How to use parameters “@” in an SQL command in VB
  16. JPQL IN clause: Java-Arrays (or Lists, Sets…)?
  17. Finding similar strings with PostgreSQL quickly
  18. Why use a JOIN clause versus a WHERE condition?
  19. How do I alter the position of a column in a PostgreSQL database table?
  20. How to unpivot in BigQuery?
  21. Get the last day of the month in SQL
  22. How to convert PostgreSQL 9.4’s jsonb type to float
  23. Find rows that have the same value on a column in MySQL
  24. Referencing current row in FILTER clause of window function
  25. SQL take just the numeric values from a varchar
  26. SQL Server 2005 – Export table programmatically (run a .sql file to rebuild it)
  27. Replacing NULL and empty string within Select statement
  28. SQL SERVER DATETIME FORMAT
  29. SQL WITH clause example [duplicate]
  30. Why isn’t row level security enabled for Postgres views?

Leave a Comment