iif – CodeRavo

Conditional Logic in SQL Server

SQL Server provides several ways to implement conditional logic within queries and stored procedures. This allows … Conditional Logic in SQL ServerRead more

CASE statement, conditional logic, else-statement, exists, if-statement, iif, performance optimization, SQL Server, T-SQL, variables

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