Re: cant get the correct num of rows from Oracle. in 2 SQL servers ( sql 7.0 and SQL 2000)

From: Melih SARICA (melihsarica_at_hotmail.com)
Date: 10/19/04 

Date: Tue, 19 Oct 2004 16:52:30 +0300

Hi Tibor..

I did Trace it on Oracle..

In trace Oracle Send number of 49439 rows for all queries, but SQL 200 and
SQL 7.0 get rows different.

And Also i did try it with an Test Oracle Server..

Its the same..

SQL 2000 get 99 rows less then SQL 7.0

"Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote in
message news:e0kGfVdtEHA.2072@tk2msftngp13.phx.gbl...
> The reason I asked to post the query was to see whether there is anything
in the query that can
> explain the difference. As I said in the original post, one such
possibility id difference regarding
> handling of NULLs.
>
> Also, did you try to catch the SQL statement submitted form SQL Server to
Oracle to see if they are
> the same from 7.0 and 2000?
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
>
> "Melih SARICA" <melihsarica@hotmail.com> wrote in message
> news:usBSPMdtEHA.4040@TK2MSFTNGP09.phx.gbl...
> > This Query is just an Example..
> >
> > When i run this query in Oracle number of rows is the same as SQL server
7.0
> > it returns 49439 ..
> >
> > Both MDAC versions are 2.8
> > Both Oracle ODBC Drivers r same 9.2.0.5
> >
> > i did try all attributes.. and check hundreds of pages from MSDN or OTN
but
> > no solution yet ..
> >
> > when i try to get records from Oracle there is always 99 rows
difference.
> > between SQL 2000 and SQL 7.0
> >
> > Not according to rowsize, or table or other things...
> >
> >
> >
> > "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote
in
> > message news:u%23c3xDdtEHA.1720@TK2MSFTNGP14.phx.gbl...
> >> Is there a tool like Profiler available for Oracle? If so, can you
trace
> > the query submitted to
> >> Oracle and see if they are the same? What if you execute the same query
> > directly on the Oracle
> >> Server? What number of rows is the correct number?
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >>
> >>
> >> "Melih SARICA" <melihsarica@hotmail.com> wrote in message
> >> news:%23pKPi9ctEHA.2520@tk2msftngp13.phx.gbl...
> >> > Ty tibor..
> >> >
> >> > Query is the same
> >> >
> >> > select count(*) from openquery(baanb,'select t$item from
> > baan.ttiitm001501')
> >> >
> >> > in SQL server 7.0 this query returns 49439
> >> >
> >> > in SQL server 2000 it returns 49340
> >> >
> >> >
> >> > and not only in this query .. if number of rows returned from the
> > openquery
> >> > statement get biggers number of lost rows get bigger too
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> > "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com>
wrote
> > in
> >> > message news:Oi34g5ctEHA.636@TK2MSFTNGP09.phx.gbl...
> >> >> Possibly handling of NULLS can cause a difference. Can you post the
two
> >> > queries?
> >> >>
> >> >> --
> >> >> Tibor Karaszi, SQL Server MVP
> >> >> http://www.karaszi.com/sqlserver/default.asp
> >> >> http://www.solidqualitylearning.com/
> >> >>
> >> >>
> >> >> "Melih SARICA" <melihsarica@hotmail.com> wrote in message
> >> >> news:%23szluxctEHA.3156@TK2MSFTNGP12.phx.gbl...
> >> >> >I ve got an Oracle 9. server running on AIx.
> >> >> >
> >> >> > and One SQL Server 2000 Sp 3on w2k
> >> >> > and SQL server 7 on Winnt 4.0
> >> >> >
> >> >> >
> >> >> > i did link this Oracle server on both SQL serevrs. When run an
simple
> >> > SQL
> >> >> > query i got different results.
> >> >> >
> >> >> > Num of rows are always different In SQL server 7.0 i got 49430
rows(
> >> > when i
> >> >> > check in oracle its correct)
> >> >> > In SQL SErver
2000
> > i
> >> > got
> >> >> > 49336 rows.
> >> >> >
> >> >> > Any idea ?
> >> >> >
> >> >> >
> >> >> >
> >> >> >
> >> >>
> >> >>
> >> >
> >> >
> >>
> >>
> >
> >
>
>

Relevant Pages

  • Re: SELECT DISTINCT slow, how can I speed up
    ... We have staff using Access 2003 as a front end to the Oracle tables ... for the purposes of ad hoc queries. ... come back within a second of the SQL starting to run. ... only 20-50 rows come back and the query takes 28 seconds and there is ...
    (comp.databases.oracle.server)
  • Re: SQL -> Oracle
    ... > 2- extracted all my SQL queries in one single file (that was the tedious ... > 3- now whenever I need new query. ... > - Sybase and SQL server prefix their parameters with '@' ... > - Firebird and Oracle have selectable stored procedures so you use them ...
    (borland.public.delphi.non-technical)
  • Re: SQL query fails
    ... You can't use the same wild card character in all db engines. ... character" wild card in MS SQL & Oracle is the underline; ... > I have a query that works in Oracle and SQL Server, ...
    (microsoft.public.access.queries)
  • Re: ORA-1866 The datetime class is invalid error...the saga continues!
    ... but you could try using a different data provider. ... Use the Microsoft ADO.NET Oracle Provider ... VB.NET to my employers and not being able to query data using a date field ... SQL statements I provided earlier will execute flawlessly in any enviornment ...
    (microsoft.public.dotnet.general)
  • Re: Linked Table Password
    ... I have a large amount of code that uses dynamic SQL. ... then change the SQL property of the query to match the current dynamic SQL ... >I assume that you are using queries to access the data in the SQL Server ... It is directed for Oracle users, ...
    (microsoft.public.access.security)