Displaying 1 result from an estimated 1 matches for "ptsecmstqa01".
2010 Nov 25
1
Execute SQL Stored Procedure in R
Dear all,
I would like R to retrieve a table resulting from execute sql stored procedures. What function can I use? Can RODBC do it.
I tried
channel1 <- odbcConnect("ptsecmstqa01-alpha")
query <- paste("execute DB.dbo.usp_test")
Data<- sqlQuery(channel1, query)
However, it returned blank.
Best Regards,
Suphajak Ngamlak
Equity and Derivatives Trading
Phatra Securities Public Company Limited
Tel: (66)2-305-9179
Email: suphajak@phatrasecurities.com
[...