Skip to content

Instantly share code, notes, and snippets.

@renatocantarino

renatocantarino/sql

Created August 6, 2013 13:33
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save renatocantarino/6164449 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save renatocantarino/6164449 to your computer and use it in GitHub Desktop.
Download ZIP
Conecta no SQL e realiza Query.
Raw
sql
library(RODBC)
cn<-odbcConnect('NW',uid='Usuario',pwd='Senha')
sql <- "select top 30 ShipName from dbo.Orders"
myresult<- (sqlQuery(cn, sql))
odbcClose(cn)
print(myresult)
@renatocantarino

renatocantarino commented Aug 6, 2013

Copy link
Copy Markdown
Author

NW = nome do Odbc

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment