SQL_Query: SQL_Query

View source: R/SQL_Functions.R

SQL_QueryR Documentation

SQL_Query

Description

SQL_Query get data from a database table

Usage

SQL_Query(
  DBConnection,
  Query,
  ASIS = FALSE,
  CloseChannel = TRUE,
  RowsPerBatch = 1024
)

Arguments

DBConnection

AutoQuant::SQL_Server_DBConnection()

Query

The SQL statement you want to run

ASIS

Auto column typing

CloseChannel

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

RowsPerBatch

Rows default is 1024

Author(s)

Adrian Antico

See Also

Other Database: AutoDataDictionaries(), PostGRE_AppendData(), PostGRE_CreateTable(), PostGRE_GetTableNames(), PostGRE_ListTables(), PostGRE_Query(), PostGRE_RemoveCreateAppend(), PostGRE_RemoveTable(), PosteGRE_CreateDatabase(), PosteGRE_DropDB(), PosteGRE_ListDatabases(), SQL_ClearTable(), SQL_DropTable(), SQL_Query_Push(), SQL_SaveTable(), SQL_Server_DBConnection()


AdrianAntico/RemixAutoML documentation built on Feb. 3, 2024, 3:32 a.m.