SQL Server IF…ELSE Statement T SQL (Part 16)

SQL Server IF…ELSE Statement T-SQL Example:
Here we learn Why do you need Conditional Statements?
In real life, you perform many actions which are dependent on the outcome of some other activity or situation.
Some real-time examples are:
If it rains tomorrow, I will plan on a road trip.
If flight tickets are less than 3000 Rs. from my city, then I will go on vacation in Goa, else I will prefer some nearby tourist spot.
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!"
Similarly, MS SQL also provides the capability to execute T-SQL statement conditionally.

-- SQL If Else Example

--Declaring Number and Total Variables
DECLARE @Marks INT = 72 ;

IF @marks greater than = 50
BEGIN
PRINT ' Congratulations ';
PRINT ' You pass the Examination ';
END
ELSE
BEGIN
PRINT ' You Failed ';
PRINT ' Better Luck Next Time ';
END