Post reply

Conversion from SQL Server 6.5 to 2000

  • October 31, 2003 at 7:12 am

    #81334

    We have been looking through the information about the upgrade to SQL2000.

    In the Critical Upgrade Decisions there is an item about JOIN types SQL6.5 ANSI syntax with WHERE clause comparison SQL2000 ANSI JOIN syntax(INNER,OUTER,FULL and CROSS)

    We use the WHERE join a lot on in this app -

    Do you know if this is still supported in SQL2000 or will we need to change our stored procedures to one of the other types of JOIN.

  • October 31, 2003 at 8:27 am

    #480462

    It is still supported . However (from the SQL Server 20000 BOL):

    quote:

    Any statements using the Transact-SQL outer joins should be changed to use the SQL-92 syntax. The syntax may not be supported in a future version of SQL Server.

    --Jonathan



    --Jonathan

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply