Description Usage Arguments Value Examples
Connect to Sql Server databases
1 | InsitesSqlConnectJDBC(disconnect = FALSE, conn = NULL, firstTime = FALSE)
|
disconnect |
TRUE/FALSE disconnect or connect |
conn |
only requeired if you want to disconnect an existing connection |
firstTime |
TRUE/FALSE if it's the first time to connect |
A conn
of database
1 2 3 4 5 6 7 8 9 10 11 | # connect
conn <- InsitesSqlConnectJDBC()
sqlquery1 <- "select capiq_symbol_ticker, capiq_symbol_exchange, pricing_date, price_close, volume from insites_metrics_dev.meta.equity_price where pricing_date between GETDATE() - 500 and GETDATE()"
sqlquery2 <- "select distinct capiq_symbol_ticker, capiq_symbol_exchange from insites_metrics_dev.meta.equity_price where pricing_date between GETDATE() - 500 and GETDATE()"
res <- dbGetQuery(conn, sqlquery1)
res <- dbGetQuery(conn, sqlquery2)
sqlText <- paste("SELECT top 10 * FROM TABLE_NAME", sep="")
queryResults <- dbGetQuery(conn, sqlText)
# disconnect
InsitesSqlConnectJDBC(disconnect = TRUE, conn)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.