search for: 42s01

Displaying 2 results from an estimated 2 matches for "42s01".

Did you mean: 4201
2011 Nov 10
1
Help: sqlSave Error
...ng table at MS SQL Server database. Previously my code ran smoothly but all of a sudden it stopped working. Here is my code: sqlSave(con, highVol, "dbo.futuresHighVol", append=TRUE, rownames=FALSE) Error: sqlSave(con, highVol, "jrgchis.dbo.futuresHighVol", append = TRUE, : 42S01 2714 [Microsoft][ODBC SQL Server Driver][SQL Server] 'futuresHighVol' already exist [RODBC] ERROR: Could not SQLExecDirect 'CREATE TABLE jrgchis.dbo.futuresHighVol ("TradeTime" varchar(255), "vol" float)' Please Help!!! -- View this message in context: http:...
2009 Mar 01
1
Temporary tables with Microsoft SQL?
...ame) : ?#x?: table not found on channel > sqlSave(channel, "#x", verbose=TRUE) #repeat Query: CREATE TABLE "#x" ("rownames" varchar(255), "x" int) Error in sqlSave(db_i3_eic, x, "#x", verbose = TRUE) : [RODBC] ERROR: Could not SQLExecDirect 42S01 2714 [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named '#x' in the database. > sqlSave(channel, "x", verbose=TRUE) # try without hash Query: CREATE TABLE "x" ("rownames" varchar(255), "x" int) Error in sqlSave(db_i3_...