Fardin:
You could alway execute the statement as a string using the
EXEC(UTE) command.
Example:
''Select * from table_name where
--
Posted via http://dbforums.com
by GodMadeIncubu » Sun, 18 Aug 2002 05:53:34
Fardin:
You could alway execute the statement as a string using the
EXEC(UTE) command.
Example:
''Select * from table_name where
--
Posted via http://dbforums.com
1. Problems reading Linked Oracle Server
Hi Fardin,
You may try the openquery like this:
Select * from openquery(linked_server_name, 'select * from table_name')
Hope this helps!
--- Simon Liao
This posting is provided "AS IS" with no warranties, and confers no rights.
2. yet another db corruption issue
3. Reliable link to Oracle server (linked, server, oracle)
4. Timeseries: Relational DB or OODBs?
5. URGENT: SQL Server 2000 to Oracle 9i Linked server problem
6. Oracle server + Designer/2000
7. SQL Server 7 Linked Server to Oracle Problem
9. SQL Server Linked-Server problem with Personal Oracle 8i
10. Problem linking to Sybase as linked server
11. Problem with linking sql server to Oracle
12. Linked Oracle Server Problem!