SQL
Writing Portable SQL
How much portability is worth paying for, which constructs are safe everywhere, and how to isolate the parts that can never be portable.
#SQL Dialects
Differences between SQL products.
5 notes tagged
SQL
PostgreSQL, MySQL, SQL Server, Oracle and SQLite Compared
One reference table for the differences that actually break code: paging, auto increment, strings, dates, upserts and the features each product lacks.
SQL
INTERSECT, EXCEPT and Column Compatibility
The two set operations MySQL waited longest to add: rows in both sets, and rows in one set but not the other - plus how to emulate them where they are...
SQL
FULL OUTER JOIN, CROSS JOIN and SELF JOIN
The three joins people meet last: keeping unmatched rows from both sides, deliberate Cartesian products, and joining a table to itself.
SQL
SQL Date and Time Functions
Current date and time, adding and subtracting intervals, differences between dates, extracting parts, and formatting - the least portable corner of SQ...