This SQL works in SQL 2000
SELECT LogId, * FROM Logs
Order by LogId DESC
This fails in SQL 2008 with the error message
Ambiguous column name 'LogId'.
How ridiculous ? Luckily not affected too much but this could have easily meant a big migration headache.
SELECT LogId, * FROM Logs
Order by LogId DESC
This fails in SQL 2008 with the error message
Ambiguous column name 'LogId'.
How ridiculous ? Luckily not affected too much but this could have easily meant a big migration headache.
Comment