Case statement in SQL Server 2008

InfoPath alternatives for form designing SharePoint

In this post we will discuss about how to use case statement in sql server 2008.

You can also check my previous posts on asp.net mvc 4 tutorial, Forms Authentication in Asp.Net and Method Overloading in C#.Net.

Syntax:

CASE expression
WHEN expression1 THEN expression1
[[WHEN expression2 THEN expression2] […]]
[ELSE expressionN]
END

Example:
select Case Gender when 0 then ‘Male’ else ‘Female’ end as Gender from UserMaster where UserID=1

The above query will return Male of Gender field is 0 else it return Female.

Also Check below example where you can have multiple WHEN statements:

select SiteURL,SiteName =
CASE SiteID
WHEN 1 THEN ‘EnjoySharePoint.com’
WHEN 2 THEN ‘AspDotNetHelp.Com’
WHEN 3 THEN ‘Fewlines4Biju.com’
ELSE ‘No Site Available’
END from WebSite

Similar SharePoint 2013 Tutorials


About Bijay Kumar

I am Bijay from Odisha, India. Currently working in my own venture TSInfo Technologies in Bangalore, India. I am Microsoft Office Servers and Services (SharePoint) MVP (5 times). I works in SharePoint 2016/2013/2010, SharePoint Online Office 365 etc. Check out My MVP Profile.. I also run popular SharePoint web site SharePointSky.com

View all posts by Bijay Kumar →

Leave a Reply