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.
| Author |
Topic |
|
osirisa
Constraint Violating Yak Guru
289 Posts |
 Posted - 2009-03-12 : 16:39:21
|
| Hi Group:This is my first time using linked Server. How can I read the tables from this other server under linked Server? How can I create a view once I open the tables in this other server? How can I extract the data and put it inside of an SQL table? Thanks for the help |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
osirisa
Constraint Violating Yak Guru
289 Posts |
Posted - 2009-03-12 : 17:02:40
|
| I am already connected with oracle, I need to find a way to retrieve the data from the Oracle Tables. |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-03-12 : 17:05:25
|
Use a SELECT statement.Books Online has examples for you. If you are uncertain, remember to use 4-part naming convention.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
|
|
|
Linked Server- Need Help