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

Comments

Popular posts from this blog

Shared / Static Class in vb.net/C#

Xamarin Forms : PopUp Page with RG.Plugins.Popup

Text was truncated or one or more characters had no match in the target code page.". (SQL Server Import and Export Wizard)