Case Vs IIF in Sql server 2012
Declare @A as int = 1
Declare @B as int = 2
Declare @C as int = 3
Declare @D as int = 4
Declare @E as int = 5
Select IIF(@A = 1, 'A','Not')
Select Case when @A = 1 then 'A' Else 'NOT' End
Select IIF(@A = 1, IIF(@B=2,IIF(@C=3,'C' ,''),''),'Not')
Select Case when @A = 1 then
Case when @B = 2 then
Case when @C = 3 Then 'C' Else '' End Else '' End Else 'NOT' End
Declare @B as int = 2
Declare @C as int = 3
Declare @D as int = 4
Declare @E as int = 5
Select IIF(@A = 1, 'A','Not')
Select Case when @A = 1 then 'A' Else 'NOT' End
Select IIF(@A = 1, IIF(@B=2,IIF(@C=3,'C' ,''),''),'Not')
Select Case when @A = 1 then
Case when @B = 2 then
Case when @C = 3 Then 'C' Else '' End Else '' End Else 'NOT' End
Comments
Post a Comment