case – CodeRavo

Finding the Maximum of Two Values in SQL Server

SQL Server doesn’t directly offer a MAX function that accepts multiple values like Math.Max in .NET. … Finding the Maximum of Two Values in SQL ServerRead more

aggregate-function, case, conditional logic, derived-table, iif, max, null-handling, SQL Server, user-defined-function

String Prefix Checking in Bash

Checking for String Prefixes in Bash This tutorial explains how to determine if a string begins … String Prefix Checking in BashRead more

Bash, case, comparison, conditional, parameter-expansion, prefix, regular-expression, Scripting, string, wildcard

Preventing Division by Zero Errors in SQL

Preventing Division by Zero Errors in SQL Division by zero is a common error in many … Preventing Division by Zero Errors in SQLRead more

arithmetic, case, data integrity, database, division-by-zero, error handling, nullif, SQL