Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Updating Timestamp Field in Oracle with Openquery

Author  Topic 

cidmi.dovic
Yak Posting Veteran

53 Posts

Posted - 2009-07-27 : 07:26:12
Hi,
I have an Oracle linked server and I want to update a Timestamp field with an Openquery update.

I can find the right query for that, I've tried a lot of casts but no one worked for me...

Any idea?
Thanks.

The Padrón peppers itch and other don't

rajdaksha
Aged Yak Warrior

595 Posts

Posted - 2009-07-27 : 07:51:00
Hi

I'm not sure whether Oracle supports explicit value insertion into a timestamp column, but SQL Server doesn't allow this.



-------------------------
R..
Go to Top of Page
   

- Advertisement -