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
On this page of the site you can watch the video online SQL Server IF…ELSE Statement T SQL (Part 16) with a duration of hours minute second in good quality, which was uploaded by the user Syed Ali 07 September 2019, share the link with friends and acquaintances, this video has already been watched 328 times on youtube and it was liked by 81 viewers. Enjoy your viewing!
