Re: Aggregate column comparison in sql server sql ?

David Portas (REMOVE_BEFORE_REPLYING_dportas@xxxxxxx) writes:
> DELETE FROM T1
> WHERE EXISTS
> (SELECT *
> FROM T2
> WHERE T1.a = T2.c
> AND T1.b = T2.d) ;

Which should be added, is a syntax that also works in Oracle.

Then again the syntax with IN that Oracle has is, as far as I know,
ANSI-compliant, so SQL Server is at fault here.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
.

Relevant Pages

  • Supporting SQL Server and Oracle query syntax
    ... Server and Oracle using the IDb* interfaces instead of using each provider ... Unfortunately we still have to deal with the differences in the SQL syntax. ... The JOIN syntax is probably the most obvious difference between SQL Server ... Dim select as SelectStatement = currentProvider.GetSelectStatement ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: using TODAY() in MS Query?
    ... I haven't used SQL Server for quite some time and I'm sure there are syntax ... differences between Oracle and SQL Server. ... "rachael" wrote: ...
    (microsoft.public.excel)
  • Re: Java and Access 2002
    ... those for any db (ie. Oracle, SQL Server etc) ... > // Bjorn A ... Prev by Date: ...
    (comp.lang.java.databases)
  • Replication from Oracle 9i to SQL Server 2000
    ... I am trying to create a Push Replication from Oracle 9i to SQL Server 2000. ... Prev by Date: ...
    (microsoft.public.sqlserver.replication)
  • Re: Where is TEMP TABLE created?
    ... >> If you think you need something else: In Oracle you only rarely need ... > Hi Mr Bakker, ... to put stuff in temp tables like you do in SQL Server. ... Prev by Date: ...
    (comp.databases.oracle.misc)