Wednesday 29 October 2014

Calling SQL Stored procedure from R


The Following lines in R calls a stored  procedure in SQL SEREVR 

library(RODBC)
conn <- odbcDriverConnect('driver={SQL Server};server=HostName;database=DatabaseName;uid=useName;pwd=Password')
query <- paste("exec  dbo.R_getData ");
res<-sqlQuery(conn, query);

1 comment:

  1. Blackjack - Casino Night - MapyRO
    Blackjack is the favorite 천안 출장샵 card game of the 정읍 출장마사지 gambling 서산 출장샵 age. It is played in casinos in Las Vegas, Nevada. 김천 출장마사지 We are the only casinos in NV where you can play 수원 출장안마 and

    ReplyDelete