Viewing 4 posts - 1 through 4 (of 4 total)
The syntax fo the insert is as follows:
insert into openquery(linkedservername, 'select Col1,Col2,Col3,col4 from Oracle_Table')
select Col1,Col2,Col3,Col4 from SQL_Server_Table;
The column names are the same in both of my tables.
Now I'm working on...
December 19, 2007 at 11:23 am
Scott,
Thanks for all the help!!! I ended up going from the original SQL Server table to a SQL Server stage table, converting the datetime to varchar as part of...
December 13, 2007 at 10:09 am
Ahhhh..The light goes on! That would certainly explain the error messages I get!
Okay, I'm thinking I can defiintely get oracle to provide the timestamp for the time the record...
December 6, 2007 at 9:48 am
In SQL*Plus I can insert a record with timestamp fields as follows:
insert into Table_Name values
('014867514',
TIMESTAMP'2003-04-03 08:37:43.593',
'ADAPTER,CONNECTOR,FIBER OPTIC',
'A00000039.jpg',
TIMESTAMP'2007-11-27 11:20:10.867' );
So, I am thinking there has to be some intermediary step...
December 5, 2007 at 7:19 am
Viewing 4 posts - 1 through 4 (of 4 total)