There are times when you want to perform conditional checks within a SQL Query in SQL Server .

Below is a sample Query that demonstrates how to do it.

Equivalent of IF Statement in SQL Server

Assume that the Employee table contains a column called “Designation” and we might want to show a value 1 if the designation is SSE else show 0 . You can do it with the below query.

SELECT CASE
   WHEN designation ='SSE'
     THEN 1
     ELSE 0
   END as SENIOR, *
FROM Employee
Equivalent of IF Statement in SQL Server

Leave a Reply

Your email address will not be published. Required fields are marked *

Liked this content?. Please spread the word :)

  • RSS
  • Twitter
    Visit Us
    Follow Me