R学习-- R连接 SQL SERVER
1.安装package
install.packages("RODBC")
2.初始化连接
dbhandle <- odbcDriverConnect('driver={SQL Server};server=.\\SQLEXPRESS;database=SDC;trusted_connection=true')
3.查询
res = sqlQuery(dbhandle, "select * from SDC_FACILITY")
install.packages("RODBC")
dbhandle <- odbcDriverConnect('driver={SQL Server};server=.\\SQLEXPRESS;database=SDC;trusted_connection=true')
res = sqlQuery(dbhandle, "select * from SDC_FACILITY")