SyntaxFix

[sql-server] SQL Server IIF vs CASE

IIF is the same as CASE WHEN <Condition> THEN <true part> ELSE <false part> END. The query plan will be the same. It is, perhaps, "syntactical sugar" as initially implemented.

CASE is portable across all SQL platforms whereas IIF is SQL SERVER 2012+ specific.

Examples related to sql-server

• Passing multiple values for same variable in stored procedure • SQL permissions for roles • Count the Number of Tables in a SQL Server Database • Visual Studio 2017 does not have Business Intelligence Integration Services/Projects • ALTER TABLE DROP COLUMN failed because one or more objects access this column • Create Local SQL Server database • How to create temp table using Create statement in SQL Server? • SQL Query Where Date = Today Minus 7 Days • How do I pass a list as a parameter in a stored procedure? • SQL Server date format yyyymmdd

Examples related to sql-server-2012

• Count the Number of Tables in a SQL Server Database • SQL Server IF EXISTS THEN 1 ELSE 2 • Get last 30 day records from today date in SQL Server • No process is on the other end of the pipe (SQL Server 2012) • How to subtract 30 days from the current date using SQL Server • Possible to restore a backup of SQL Server 2014 on SQL Server 2012? • SQL Server: Best way to concatenate multiple columns? • SQL Server - An expression of non-boolean type specified in a context where a condition is expected, near 'RETURN' • SSIS Excel Connection Manager failed to Connect to the Source • Sql server - log is full due to ACTIVE_TRANSACTION

Examples related to case

• PostgreSQL CASE ... END with multiple conditions • SQL Server: use CASE with LIKE • SQL Server IIF vs CASE • SELECT using 'CASE' in SQL • SELECT query with CASE condition and SUM() • GROUP BY + CASE statement • SQL use CASE statement in WHERE IN clause • SQL Server - Case Statement • where to place CASE WHEN column IS NULL in this query • Regarding Java switch statements - using return and omitting breaks in each case

Examples related to iif

• SQL Server IIF vs CASE • How to use multiple conditions (With AND) in IIF expressions in ssrs • Line break in SSRS expression • ORACLE IIF Statement • JavaScript: IIF like statement