Remember we stated that the ELSE part is optional. You can use an IF statement in SQL without an ELSE part. Select * from Guru99 where Tutorial_ID = 3 Select * from Guru99 where Tutorial_ID = 2 Select * from Guru99 where Tutorial_ID = 1 Select * from Guru99 where Tutorial_ID != 4 Select * from Guru99 where Tutorial_ID = 4 We will use ‘Guru99’ table in further examples IF…ELSE with the variable in Boolean Expression. PRINT 'ELSE STATEMENT: CONDITION IS FALSE'Īssumption: Assume that you have the table as ‘Guru99’ with two columns and four rows as displayed below: IF…ELSE with the only numeric value in Boolean Expression. IF…ELSE with the variable in Boolean Expression.Similarly, MS SQL also provides the capability to execute T-SQL statement conditionally. Here, you can see that one action, like Road trip above, is conditionally dependent on the outcome of another activity which is “whether it will rain or not tomorrow!” If flight tickets are less than $400 from my city, then I will go on vacation in Europe, else I will prefer some nearby tourist spot.If it rains tomorrow, I will plan on a road trip.Some real-time examples of SQL case statement are:

In real life, you perform many actions dependent on the outcome of some other activity or situation. It allows you to perform different actions based on conditions defined within the statement. Conditional statements in the SQL server help you to define different logics and actions for different conditions.

Sql server select into