Powered by Blogger.

Saturday, February 15, 2014

Case statement in SQL Server 2008

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

- Method Overloading in C#.Net


CASE expression
WHEN expression1 THEN expression1
[[WHEN expression2 THEN expression2] [...]]
[ELSE expressionN]

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