TSQL 2012 IFF Function
In a nutshell, IFF function is a shorthand for Case function. Here is the example to illustrate its use and syntax.
Create database myDB;
Go
Use myDB;
Go
Create table Employees (id int, name nvarchar(30), city nvarchar(30), region nvarchar(30), country nvarchar(30));
Go
Insert some records to play with. (more…)