mapDataTypes: Determine SQL Server data types from data frame. Follows SQL...

In bcputility: Wrapper for SQL Server bcp Utility

Determine SQL Server data types from data frame. Follows SQL Server data type size constraints and chooses the smallest data type size.

Description

Determine SQL Server data types from data frame. Follows SQL Server data type size constraints and chooses the smallest data type size.

Usage

mapDataTypes(x, coltypes)

varChar(x)

varBinary(x)

int(x)

Arguments

x	data.frame object
coltypes	vector with names of columns to override the default data type mapping

Value

character vector with names of columns

Examples

mapDataTypes(data.frame(
  int = 1:5L,
  numeric = seq(0, 1, length.out = 5),
  character = LETTERS[1:5],
  factor = paste(LETTERS[1:5], LETTERS[1:5], sep = ''),
  logical = c(TRUE, FALSE, TRUE, FALSE, TRUE),
  date = seq(Sys.Date() - 4, Sys.Date(), 1L),
  datetime = seq(Sys.time() - 5, Sys.time(), length.out = 5)
  )
)

bcputility documentation built on June 22, 2024, 11:55 a.m.