|
Home > Archive > MS SQL Server Tools > December 2005 > different results query analizer vs. enterprise manager
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
different results query analizer vs. enterprise manager
|
|
| peppi911@hotmail.com 2005-12-30, 11:23 am |
| hi,
i have a query which i run in query analyzer.
if i copy it to the enterprise manager it rearranges
my query. this is not a problem for me, but the result is
different, there are different numbers of rows given back.
is that a known bug, or are there some things i can do
to change that behaviour? with this i do still not know
which result is right....
greetings,
mike
| |
| Michael Hotek 2005-12-30, 11:23 am |
| Do you have a query to post which might help us a bit more?
--
Mike
Mentor
Solid Quality Learning
http://www. solidqualitylearning
.com
<peppi911@hotmail.com> wrote in message
news:1135957879.649605.82940@z14g2000cwz.googlegroups.com...
> hi,
> i have a query which i run in query analyzer.
> if i copy it to the enterprise manager it rearranges
> my query. this is not a problem for me, but the result is
> different, there are different numbers of rows given back.
> is that a known bug, or are there some things i can do
> to change that behaviour? with this i do still not know
> which result is right....
>
> greetings,
> mike
>
| |
| Erland Sommarskog 2005-12-31, 11:23 am |
| (peppi911@hotmail.com) writes:
> i have a query which i run in query analyzer.
> if i copy it to the enterprise manager it rearranges
> my query. this is not a problem for me, but the result is
> different, there are different numbers of rows given back.
> is that a known bug, or are there some things i can do
> to change that behaviour? with this i do still not know
> which result is right....
I assume that you mean the View/Query Designer in Enterprise Mangager?
Yes, this is known to rearrange queries, and sometimes in a fashion
that alters the result. The tool can be nice for demos, and simple
queries, but you outgrow it pretty quick, as it is not very capable
with complex queries.
And, no, it has not been improved in SQL 2005. It still can mangle
your queries. But to make matters worse, it is now more exposed.
Generally, I would recommend you to stay away from that tool. Run
your queries from Query Analyzer, or the Query Editor in Mgmt Studio.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
|
|
|
|
|