Search code examples
sqlrrodbc

RODBC sqlQuery vs sqlFetch

What is the difference bewteen the two RODBC functions: sqlQuery and sqlFetch?

Solution

  • You can send this command:

    library(RODBC)
?sqlQuery
?sqlFetch

    And from the guide:

    sqlQuery: Submit an SQL query to an ODBC database, and retrieve the results.

    sqlFetch: Read some or all of a table from an ODBC database into a data frame.