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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy