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
Sur cette page du site, vous pouvez voir la vidéo en ligne SQL Server IF…ELSE Statement T SQL (Part 16) durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Syed Ali 07 septembre 2019, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 328 fois et il a aimé 81 téléspectateurs. Bon visionnage!
