Re: Performance: Conditions in WHERE clause vs. conditions in INNER JOIN?

On 7 Nov., 23:09, DA Morgan <damor...@xxxxxxxxx> wrote:
MINUS is a set operator similar to INTERSECT, UNION, and UNION ALL
which, as you point out, is equvalent to EXCEPT in SQL Server.

I can appreciate some of Bill's frustration when it comes to things
such as analytic functions and regular expressions but in set operators
SQL Server and Oracle are equivalent.

Yeahh and hopefully they will introduce also INTERSECT ALL and EXCEPT
(MINUS) ALL.

Gints Plivna
http://www.gplivna.eu
.

Relevant Pages

  • Re: ASP.NET Application Gets Frequent SQL Timeout Exceptions
    ... Sorry I feel your frustration, however If anyone is to help you we need far ... and post the query plan here. ... You should be able to get the queries ... I have used Oracle and SQL Server and any DB will have its problems ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Any new analytic SQL Features in SQL2005?
    ... SQL Server 2005 is slated to provide several analytic functions not ... name a few, as well as quite a few other new language features, like ... Oracle uses CONNECT BY for. ...
    (microsoft.public.sqlserver.programming)