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