Displaying 1 result from an estimated 1 matches for "db_i3_eic".
2009 Mar 01
1
Temporary tables with Microsoft SQL?
..."rownames" varchar(255), "x" int)
Error in sqlColumns(channel, tablename) :
?#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&...