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")