当前位置：Gxlcms > 数据库问题 > R基础学习（二）-- 连接sqlserver

R基础学习（二）-- 连接sqlserver

时间：2021-07-01 10:21:17 帮助过：8人阅读

.packages(‘RODBC‘) Installing package into ‘C:/Users/lmei/Documents/R/win-library/3.5’ (as ‘lib’ is unspecified) trying URL ‘https://cran.rstudio.com/bin/windows/contrib/3.5/RODBC_1.3-15.zip‘ Content type ‘application/zip‘ length 879575 bytes (858 KB) downloaded 858 KB package ‘RODBC’ successfully unpacked and MD5 sums checked The downloaded binary packages are in C:\Users\lmei\AppData\Local\Temp\Rtmp6Fwdfk\downloaded_packages

（3）编写R脚本，ConnectSqlServer.R（‘myData’为第一步创建ODBC数据源时填写的名称），代码如下，运行代码

library(‘RODBC‘)
myConn <- odbcConnect(‘myData‘,uid=‘sa‘,pwd=‘123456‘)
count = sqlQuery(myConn,"select count(*) from tb_test")
print(count)

console输出

> library(‘RODBC‘)
> myConn<-odbcConnect(‘myData‘,uid=‘sa‘,pwd=‘123456‘)
> count = sqlQuery(myConn,"select count(*) from tb_test")
> print(count)
      
1 4491

这样完成了R连接sqlserver，并进行数据查询！

R基础学习（二）-- 连接sqlserver

标签：输出脚本查询 bubuko download rod 数据查询 library ase

R基础学习（二）-- 连接sqlserver

人气教程排行