IIF SQL Function
IIF() is built-in logical function and introduced in Sql Server 2012.
It is similar to CASE and IF statements in SQL Server. by this we can minimize the sql code.
Syntax:- IIF( expression, true_value, false_value )
Example:-
1:- Compare two dates with IIF()
SELECT IIF('10/24/2016' > '01/01/1987','Eligible ','Not Eligible ') AS 'Output'
GO
Output
------
Eligible
2:- Compare two integer variables with IIF()
DECLARE @num1 AS INT = 18
DECLARE @age AS INT = 11
SELECT IIF( @age > @num1, '18 above', '18 below') AS 'Output'
GO
Output
------
18 below
IIF() is built-in logical function and introduced in Sql Server 2012.
It is similar to CASE and IF statements in SQL Server. by this we can minimize the sql code.
Syntax:- IIF( expression, true_value, false_value )
Example:-
1:- Compare two dates with IIF()
SELECT IIF('10/24/2016' > '01/01/1987','Eligible ','Not Eligible ') AS 'Output'
GO
Output
------
Eligible
2:- Compare two integer variables with IIF()
DECLARE @num1 AS INT = 18
DECLARE @age AS INT = 11
SELECT IIF( @age > @num1, '18 above', '18 below') AS 'Output'
GO
Output
------
18 below
No comments:
Post a comment