• They will perform the same (same execution plan), the only difference is one uses the ANSI syntax and the other the old style SQL Server / Sybase syntax.

    Robert Murphy, Microsoft MCITP (Database Administrator 2008) and MCAD Certified