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 is the fast way
to do it? Thank you very much.
--
View this message in context:
http://r.789695.n4.nabble.com/Write-to-MS-SQL-Database-tp4649522.html
Sent from the R help mailing list archive at Nabble.com.
[[alternative HTML version deleted]]
