Oracle’s dual table—In SQL Server, you may have some cases where the statement SELECT ‘x’; is used. In Oracle, that statement must be translated to SELECT ‘x’ FROM dual;.

Concatenation —SQL Server 7 didn’t support the ANSI || method of concatenation, but SQL Server 2000 does. Both can use a plus (+) character to indicate concatenation, but it should be reserved ...