If you’d like to help fund Wise Owl’s conversion of tea and biscuits into quality training videos you can click this link http://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
By Andrew Gould
http://www.wiseowl.co.uk – IF statements in SQL allow you to check if a condition has been met and, if so, to perform a sequence of actions. This video teaches you everything from the basic syntax of IF statements, including how to use the ELSE clause and perform multiple actions using a BEGIN and END block. We’ll also teach you how to nest your IF statements, including a few useful tips on how to make your nested IFs readable!
You can see more examples of IF in written form here:
You can download the script to create the Movies database used in this video at the following link:
You can see the range of resources and courses we offer in SQL Server…
sql tutorial for beginners with examples