Welcome to Sign in | Help

Re: diferente la syntaxa sql server 2000/2005

  •  12-01-2008, 5:13 PM

    Re: diferente la syntaxa sql server 2000/2005

    crestinul:

    Ma gandesc ca MS putea sa pastreze vechea sintaxa ,ca fiind obsolete, si cea noua pt cei ce voia sa scrie aplicatii compatibile cu standardul ansi sql ,astfel se eliminau si problemele ce apar cand portai aplicatii din versiunile mai vechi pe 2005



    Cum dealtfel MS a si facut cind compatibility level este setat la 80:

    MSDN:

    Compatibility level setting of 80 or lower: The *= and =* operators for outer join are supported with a warning message.

     Compatibility level setting of 90 : These operators are not supported; the OUTER JOIN keyword should be used.



    http://rusanu.com
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems