Showing posts with label case in sql server. Show all posts
Showing posts with label case in sql server. Show all posts

Wednesday, 20 March 2013

Use of Case in SQL Server

Written By:- Isha Malhotra
Our Website:-Tech Altum
Use of Case in SQL Server
Sometimes we need to show the data of table in different way at runtime. In this situation we can use case statement with select query.
For Example:-
Suppose we have the following table:-
Figure 1