Friday, 20 October 2017

IFF Function in SQL SERVER 2012

IFF function :

   IFF function takes three parameters a)boolean expression b)parameter1 c)parameter2
  •     if boolean expression true then it returns parameter1 else parameter2
         Example:DECLARE @gender int;
                        SET @gender=2
                        SELECT IIF(@gender=1,'Male','female') Gender

                     output:female

No comments:

Post a Comment