select_gen_sqlserver: 定义sqlserver的语句自动生成函数

In takewiki/tsda: data access and driver interface in takewiki solutions

定义sqlserver的语句自动生成函数

Description

定义sqlserver的语句自动生成函数

Usage

select_gen_sqlserver(
  table_name = "T_GL_VOUCHER",
  col_vec = c("FDATE", "FYEAR", "FPERIOD", "FBILLNO"),
  row_where_expr = NULL,
  order_vec = NULL,
  order_asc_logical = NULL
)

Arguments

table_name	表名称
col_vec	字段名向量
row_where_expr	where表达式，完全使用tsql语法
order_vec	排序字段
order_asc_logical	逻辑表达式TRUE表示asc,FALSE表示desc

Value

返回值

Examples

bb <- select_gen_sqlserver(table_name='T_GL_VOUCHER',
col_vec=c('FDATE','FYEAR','FPERIOD','FBILLNO'),
row_where_expr="FDATE>='2019-01-01' and fdate <= '2019-03-31' ",order_vec=c('FDATE','FBILLNO'),order_asc_logical=c(T,T));
bb;
cc <- select_gen_sqlserver(table_name='T_GL_VOUCHER',
col_vec=c('FDATE','FYEAR','FPERIOD','FBILLNO'),
row_where_expr=NULL,order_vec=c('FDATE','FBILLNO'),order_asc_logical=c(F,T));
cc;
dd <- select_gen_sqlserver(table_name='T_GL_VOUCHER',
col_vec=c('FDATE','FYEAR','FPERIOD','FBILLNO'),
row_where_expr=NULL);
dd;

takewiki/tsda documentation built on Oct. 23, 2023, 3:28 a.m.