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 |
|
khalik
Constraint Violating Yak Guru
443 Posts |
 Posted - 2002-04-18 : 03:14:42
|
| hi when i access oracle data from sql server usingserver..owner.table the row return is not the same when i excute the same in oracle... i have notice it serval time... did any one face such problemis there a problem with sql..======================================Ask to your self before u ask someone |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-04-18 : 04:28:07
|
| khalik , did you specify any default database in your linked server.otherwise the correct syntax is server.database.owner.tablename --------------------------------------------------------------Edited by - Nazim on 04/18/2002 04:33:03 |
 |
|
|
joldham
Wiseass Yak Posting Master
300 Posts |
Posted - 2002-04-18 : 08:08:42
|
| khalik,When you say the row returned is not the same, can you give an example? I know some of the processing in Oracle is a little different than it is in SQL Server. For instance, when sorting on a column with Null values, SQL Server will place the Null values first, whereas Oracle will place Null values last. It might be helpful if you can post your SELECT statements and results.Jeremy |
|
|
|
khalik
Constraint Violating Yak Guru
443 Posts |
Posted - 2002-04-19 : 00:56:50
|
| thanks a lot.. nazim and joldham i am working with oracel and user is mapped to the database.. ie.when login can access only one database...so the syntax works...what i ment by result is the no of rows....sql server returns less rows when compare to oraclenot sure when and why....======================================Ask to your self before u ask someone |
|
|
|
|
|
|
access Oracle through sql