SQL
CASE, COALESCE, NULLIF and Conversion Functions
Conditional logic inside a query, NULL substitution, safe division and explicit type conversion - four tools that remove most procedural code from SQL...
#Functions
Built in scalar and conversion functions.
4 notes tagged
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...
SQL
SQL Numeric Functions
Rounding, truncating, absolute values, modulo and integer division - and the rounding rules that decide whether your invoice totals balance.
SQL
SQL String Functions
Concatenating, trimming, slicing, replacing and searching text - and which of these functions changes name in every dialect.