bcpWrite: Bcp write

In bowerth/stan: Structural Analysis

Description

Use bcp to write to SQL

Usage

bcpWrite(x = NULL, table = NULL, server = NULL, bcpIN = "-w -T")

Arguments

x	a dataframe object with the data to be written to SQL.
table	a character string specifying the SQL table in the form [DBname].dbo.[TableName].
server	a character string specifying the SQL server containing the database specified with ‘table’.
bcpIN	a character string passing additional argumens to the bcp utility for reading data into Microsoft SQL Server.

Details

Use the bcp utility to write data to a table on Microsoft SQL Server

Author(s)

OECD STAN

See Also

bcpRead

Examples

x <- data.frame("values"=c(1:10))
bcpWrite(x=x, table="STAN.dbo.STANPUB", server="VS-GEN-SQL-3")

bowerth/stan documentation built on May 13, 2019, 12:38 a.m.