From a functional perspective, the core SQL support in all major and minor RDBMS-es is reasonably similar. In this light, it's sometimes quite disturbing to find how some very basic things work so differently across different products. Consider this simple statement:
SELECT 'a' /* this is a comment */ 'b'
What should the result be? (You can assume that
onerow is an existing table that contains one
It turns out popular RDBMS-es mostly disagree with one another.
In Oracle XE, we get this:
SELECT 'a' /* comment */ 'b'[Read more...]