SQL Server INLINE IF ELSE

by

I understand that this question (which shows up at the top of google results for “sql server inline if”) is 2 years old, but with SQL Server 2012, the answers are somewhat outdated. It also appears to be a duplicate of SQL inline if statement type question, but that question (being an even older one), doesn’t have an up to date answer either.

In SQL Server 2012 you can use the IIF function:

IIF ( boolean_expression, true_value, false_value )

Example:

SELECT IIF(someColumn = 1, 'yes', 'no')

Related Contents:

  1. SQL Server Profiler – How to filter trace to only display events from one database?
  2. How can you represent inheritance in a database?
  3. SQL Server Text type vs. varchar data type [closed]
  4. How do I flush the PRINT buffer in TSQL?
  5. insert a NOT NULL column to an existing table
  6. SQL Server Installation – What is the Installation Media Folder?
  7. “Server” vs “Data Source” in connection string
  8. No process is on the other end of the pipe (SQL Server 2012)
  9. SQL Server 2008 Windows Auth Login Error: The login is from an untrusted domain
  10. SQL-Server: Is there a SQL script that I can use to determine the progress of a SQL Server backup or restore process?
  11. What’s the best way to store co-ordinates (longitude/latitude, from Google Maps) in SQL Server?
  12. How can you tell what Tables are taking up the most space in a SQL Server 2005 Database?
  13. How to query for Xml values and attributes from table in SQL Server?
  14. The database owner SID recorded in the master database differs from the database owner SID
  15. How to Use UTF-8 Collation in SQL Server database?
  16. SQL count rows in a table
  17. SQL Server Profiler : How to specify multiple values for “NOT LIKE” column filter
  18. SQL – The conversion of a varchar data type to a datetime data type resulted in an out-of-range value
  19. Is it safe to have SQL Server auto-shrink turned on?
  20. How to update a CLR Assembly without dropping assembly from SQL Server
  21. SQL Server: combining multiple rows into one row
  22. UPDATE OUTPUT into a variable
  23. Is a single SQL Server statement atomic and consistent?
  24. Error: TCP Provider: Error code 0x2746. During the Sql setup in linux through terminal
  25. Diagnosing Deadlocks in SQL Server 2005
  26. Restoring SQL Server backup to Azure SQL Database
  27. What is the use of WITH TIES keyword in SELECT statement in SQL Queries?
  28. How to import a bak file into SQL Server Express
  29. How to set value to variable using ‘execute’ in t-sql?
  30. Cannot find either column “dbo” or the user-defined function or aggregate “dbo.Splitfn”, or the name is ambiguous
  31. 64 bit Microsoft SQL Server Data Tools
  32. Replace single quotes in SQL Server
  33. Scheduled run of stored procedure on SQL server
  34. Does inserting data into SQL Server lock the whole table?
  35. How To change the column order of An Existing Table in SQL Server 2008
  36. SQL Server: UPDATE a table by using ORDER BY
  37. Cannot use special principal dbo: Error 15405
  38. Select All as default value for Multivalue parameter
  39. Find a string by searching all stored procs in SQL Server Management Studio 2008
  40. SQL Server truncation and 8192 limitation
  41. Get last 30 day records from today date in SQL Server
  42. SSIS Excel Connection Manager failed to Connect to the Source
  43. How do I add a “last modified” and “created” column in a SQL Server table?
  44. Update SQL with consecutive numbering
  45. Differences Between Drivers for ODBC Drivers
  46. In SSMS, how do I change a SQL query window’s tab name?
  47. SQL Server, How to set auto increment after creating a table without data loss?
  48. How to connect to SQL Server with windows authentication from Node.JS using mssql module
  49. How to save select query results within temporary table?
  50. Delete from a table based on date [closed]

Leave a Comment