November 22, 2007 at 8:54 am
Is it possible? We're running SQL 2000, and 2005 soon.
Thanks
November 22, 2007 at 9:37 pm
Haven't tried it in a view before... you must either create a Linked Server or use OPENROWSET or OPENDATASOURCE.
--Jeff Moden
Change is inevitable... Change for the better is not.
November 23, 2007 at 8:28 am
First create a linked server to Oracle server. Then select *
into MyTableName
from openquery(YourLinkedServerName, 'place query text here') FYI Oracle does not seem to understand " quotes so I always use ''two single ticks.
February 24, 2008 at 2:16 pm
Hi,
You can achieve this by having linked server in SQL Server.
Check out the below link
http://www.sqlmag.com/Article/ArticleID/22264/sql_server_22264.html
Thanks -- Vj
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply