Learn R Programming

mssqlR

Use mssqlR to query data from MS SQL Server. Based on the concept on Entity Framework, the package allows querying data from MS SQL Server Database.

Copy Link

Version

Install

install.packages('mssqlR')

Monthly Downloads

5

Version

1.0.0

License

GPL (>= 3) | file LICENSE

Maintainer

Abhishek Sinha

Last Published

June 20th, 2017

Functions in mssqlR (1.0.0)

trim

Trims leading and trailing whitespaces
where

Generates where part of a query
connect_db

Connect Function
connect_entity_gen

Connect to Database Server and Generate Entity Details Function
orderby

Generates order by part of a query
select

Generates Select part fo the query
exec

Executes the query
from

Generates from part for the query