RemixAutoML (version 0.5.0)

SQL_UpdateTable: SQL_UpdateTable

Description

SQL_UpdateTable update a database table

Usage

SQL_UpdateTable(
  DataToPush,
  DBConnection,
  SQLTableName = "",
  Index = NULL,
  CloseChannel = TRUE,
  Verbose = TRUE,
  Test = FALSE,
  NAString = "NA",
  Fast = TRUE
)

Arguments

DataToPush

Update data table in warehouse with new values

DBConnection

RemixAutoML::SQL_Server_DBConnection()

SQLTableName

The SQL statement you want to run

Index

Column name of index

CloseChannel

TRUE to close when done, FALSE to leave the channel open

Verbose

TRUE or FALSE

Test

Set to TRUE to see if what you plan to do will work

NAString

Supply character string to supply missing values

Fast

Set to TRUE to update table in one shot versus row by row

See Also

Other Database: AutoDataDictionaries(), ExecuteSSIS(), SQL_ClearTable(), SQL_DropTable(), SQL_Query_Push(), SQL_Query(), SQL_SaveTable(), SQL_Server_BulkPull(), SQL_Server_BulkPush(), SQL_Server_DBConnection()