I tried to run the following query it is not fetching all of the records
select * from openquery(ORACLE,'select * from "TableName"') it returns 10795 records
When I tried to find out the total no of records using the following query
select * from openquery(ORACLE,'select Count(*) from "TableName"') it displayed that there are 10894 record
Here the linked server is Microsoft OlE Db Provider for ODBC Drivers and it is connected to Oracle.
Please provide suggesstions regarding this..
balaji
...
Go to the complete details ...