Re: Why can’t recursive queries contain...?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

MS SQL Server is a minimal subset of the ANSI/ISO Standards. In
Standard SQL, the WITH clause is "WITH [RECURSIVE]<cte name>" so that
the compiler gets to change modes when a CTE is recursive. There are
other differences. I am at speaking at PASS now and then going to SQL
Connections, so I do not have my Standards with me; Google around for
it.

I think the Standard might allow for any set operator between the
fixpoint table expression that does not cause infinite recursion.


.

Relevant Pages

  • Re: CTE
    ... derived table (I am not talking about recursion). ... That sounds wrong in my eyes, because they are logically the same and ... To hold the intermediate the result of the CTE or derived table? ... in multiplce places in the query, you might prefer if SQL Server ...
    (microsoft.public.sqlserver.programming)
  • Re: Help with ROW_NUMBER and recursive query
    ... The role goes in front of the base data element name, ... declarations are dialect, The correct syntax is INSERT INTO, etc. ... People used to make fun of me in SQL Server ... WITH RECURSION Volkswagen ...
    (microsoft.public.sqlserver.programming)
  • Re: Why will we never see anything even remotely resembling decent standards compliance in SQL Serve
    ... > it is a considerable undertaking to cram in all the features that would ... *Anyone* who writes any code for SQL Server should demand standars compliance ... SQL Server already uses such mechanisms to govern code-breaking standards ...
    (microsoft.public.sqlserver.server)
  • Re: Persisting ADO as XML - almost convinced im crazy!
    ... bah, stupid non standards ... lol .. ... all hail .NET ... > Columnist, SQL Server Professional ...
    (microsoft.public.vb.database.ado)