Other packages > Find by keyword >

sqlcaser  

'SQL' Case Statement Generator
View on CRAN: Click here


Download and install sqlcaser package within the R console
Install from CRAN:
install.packages("sqlcaser")

Install from Github:
library("remotes")
install_github("cran/sqlcaser")

Install by package version:
library("remotes")
install_version("sqlcaser", "0.2.0")



Attach the package and use:
library("sqlcaser")
Maintained by
Leoson Hoay
[Scholar Profile | Author Map]
All associated links for this package
First Published: 2023-11-24
Latest Update: 2023-11-24
Description:
Includes built-in methods for generating long 'SQL' CASE statements, and other 'SQL' statements that may otherwise be arduous to construct by hand. The generated statement can easily be concatenated to string literals to form queries to 'SQL'-like databases, such as when using the 'RODBC' package. The current methods include casewhen() for building CASE statements, inlist() for building IN statements, and updatetable() for building UPDATE statements.
How to cite:
Leoson Hoay (2023). sqlcaser: 'SQL' Case Statement Generator. R package version 0.2.0, https://cran.r-project.org/web/packages/sqlcaser
Previous versions and publish date:
No previous versions
Other packages that cited sqlcaser R package
View sqlcaser citation profile
Other R packages that sqlcaser depends, imports, suggests or enhances
Functions, R codes and Examples using the sqlcaser R package
Some associated functions: casewhen . inlist . updatetable . 
Some associated R codes: casewhen.R . inlist.R . updatetable.R .  Full sqlcaser package functions and examples
Downloads during the last 30 days
Get rewarded with contribution points by helping add
Reviews / comments / questions /suggestions ↴↴↴

Today's Hot Picks in Authors and Packages

mistral  
Methods in Structural Reliability
Various reliability analysis methods for rare event inference (computing failure probability and qua ...
Download / Learn more Package Citations See dependency  
rdbnomics  
Download DBnomics Data
R access to hundreds of millions data series from DBnomics API (). ...
Download / Learn more Package Citations See dependency  
critpath  
Setting the Critical Path in Project Management
Solving the problem of project management using CPM (Critical Path Method), PERT (Program Evaluation ...
Download / Learn more Package Citations See dependency  
ftaproxim  
Fault Tree Analysis Based on Proxel Simulation
Calculation and plotting of instantaneous unavailabilities of basic events along with the top event ...
Download / Learn more Package Citations See dependency  
quickcode  
Quick and Essential 'R' Tricks for Better Scripts
The NOT functions, 'R' tricks and a compilation of some simple quick plus often used 'R' codes to im ...
Download / Learn more Package Citations See dependency  
steepness  
Testing Steepness of Dominance Hierarchies
The steepness package computes steepness as a property of dominance hierarchies. Steepness is define ...
Download / Learn more Package Citations See dependency  

22,114

R Packages

188,080

Dependencies

55,244

Author Associations

22,115

Publication Badges

© Copyright 2022 - present. All right reserved, rpkg.net. Contact Us / Suggestions / Concerns