Displaying 1 result from an estimated 1 matches for "sqlchannel".
Did you mean:
schannel
2012 Nov 14
0
Write to MS SQL Database
I want to update a column of a database table (in MS SQL) using sqlUpdate( )
or sqlSave( ) function in "RODBC" package. E.g. SQLchannel is the database
connection; SQLtable is the destination table in the database, including at
least two columns, ID and Value; Xdata is a data frame in R environment,
including two columns: ID and Value. What I wanna do is to update the Value
in SQLtable using Xdata, with ID as the primary key. Which...