Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Jan 24, 2013 02:49 AM by wmec
Jan 23, 2013 01:27 PM|LINK
There is some legacy code here that is using the old-style (non ansi) joins, you know the
FROM TableA, TableB
The question I have is this: will the old style joins such as the example above still work in sql server versions after SQL Server 2008?
Are there performance issues in using the old style joins in SQL Server 2008?
Jan 23, 2013 01:39 PM|LINK
They will work and will probably be slower than joining in the from clause.
Jan 23, 2013 03:44 PM|LINK
The join syntax (old-style) you are using is ANSI SQL-89 standard syntax:
SELECT * FROM TableA, TableB WHERE TAbleA.ID=TableB.ID
The newer one is ANSI SQL-92 syntax with JOIN:
SELECT * FROM TableA INNER JOIN TableB ON TAbleA.ID=TableB.ID
Both of them are fully supported by database engine and interpreted in the same way.
You will not see any performance difference between the two. But the newer one (SQL-92) is safer to write code.
Jan 24, 2013 02:49 AM|LINK