EM query builder problem

I'm aware that this query doesn't make sense but it demonstrates a problem
with the query builder. The query executes in query analyser.
I prefer using EM over query analyser for the most part because it allows
changing values in the results pane, but why does it change perfectly good
queries?
Try this...
use Northwind
SELECT *
FROM orders
WHERE binary_checksum(*) <> (SELECT binary_checksum(*) FROM customers
WHERE orders.customerid = customers.customerid)
I haven't tried this, but EM is not really the tool for running queries. You
are better off switching to Query Analyzer for running queries. EM does so
many things behind the scenes, that are not very obvious.
I wrote an article on this topic at:
http://vyaskn.tripod.com/sql_enterpr...r_or_t-sql.htm
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"news.microsoft.com" <deo.is@.unknown.com> wrote in message
news:OpDL9S3aEHA.1248@.TK2MSFTNGP11.phx.gbl...
I'm aware that this query doesn't make sense but it demonstrates a problem
with the query builder. The query executes in query analyser.
I prefer using EM over query analyser for the most part because it allows
changing values in the results pane, but why does it change perfectly good
queries?
Try this...
use Northwind
SELECT *
FROM orders
WHERE binary_checksum(*) <> (SELECT binary_checksum(*) FROM customers
WHERE orders.customerid = customers.customerid)
|||If it's not for running queries then why is there a query builder / mangler?
Looks like I'll have to find a third party app then. QA doesn't do what I
need.
I'm not asking for anything but the bugs to be fixed.
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:%23nsy4MXbEHA.1548@.TK2MSFTNGP12.phx.gbl...
> I haven't tried this, but EM is not really the tool for running queries.
You
> are better off switching to Query Analyzer for running queries. EM does so
> many things behind the scenes, that are not very obvious.
> I wrote an article on this topic at:
> http://vyaskn.tripod.com/sql_enterpr...r_or_t-sql.htm
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "news.microsoft.com" <deo.is@.unknown.com> wrote in message
> news:OpDL9S3aEHA.1248@.TK2MSFTNGP11.phx.gbl...
> I'm aware that this query doesn't make sense but it demonstrates a problem
> with the query builder. The query executes in query analyser.
> I prefer using EM over query analyser for the most part because it allows
> changing values in the results pane, but why does it change perfectly good
> queries?
> Try this...
> use Northwind
> SELECT *
> FROM orders
> WHERE binary_checksum(*) <> (SELECT binary_checksum(*) FROM customers
> WHERE orders.customerid = customers.customerid)
>
>