SQL Server Programming Part 5 - IF Statements

By Andrew Gould

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 here:

[Rational]

These are really superb series...all vedios are crisp and clear.. directly goes into brain..I wish I would've come here very long before..but I am sure it will take me beyond from here

[yeknafaskesh]

I found that I needed to add USE MOVIES before the command at 9:20 for it to work.
Thanks for the videos.

[krismaly]

I enjoyed the video.
Especially BEGIN, END and RETURN key words use.

Thanks a lot for educating me.

[padneymashaba]

well illustrated and clear explanation, Thank you

[MattGarcia]

Great Video. Straight forward and easy to follow. Thank you!

[mistery]

Bravo! Andrew. Well learned is well taught.Thanks, indeed.

[arslanali]

its very simple and goes straight to your mind, thanks for great tutorials !

[KshitijHimani]

Hard to find such simple great n thanks for this informative vid:)

[kiransurvase]

Excellent video Teaching....Goood you....

[jebanenigers]

good job, thank you very much, please more :)

[anditruman]

Hi Andrew,

excellent video as always.
Could you post the types of genres there are in the DB?
Thanks again.
Andi

[priyasridhar]

Awesome videos.Learnt a lot. Enjoyed everymoment

[RobAnybody]

Absolutely first-class. Thanks so much for the education!

[eshwarchow]

thanq sir...u provided beautiful explanation for nested-if and if in stored procedures..can i expect videos regarding while, triggers, views from you..

[Roman-ucbs]

As written, wouldn't it still return "You must choose ALL, AWARD, or FINANCIAL" even if you DID provide one of those three when executing the procedure? Wouldn't you have to nest those IF statements and then have the last SELECT statement after an ELSE statement?

[JoeG]

Awesome! I appreciate it, that would really help with something I'm working on at work where I have to use a matrix and let the user select the row, column or data fields. The error I was getting referred to a data type issue and I'm not sure what I'm doing wrong in the example - again thank you for your help - your videos are outstanding.

[dhruvipatel]

Sorry sir but I would like to know how to add 'FilmGenreID' in my Film table cuz I don't see that column in table

[BijouBakson]

2 question please:

1- What's the purpose of ( ) on the SELECT Statement within the first IF statements, doesn't the BEGIN & END do the job of telling the system what to return?

2 - Could you have used an ELSE clause for that last statement? if yes, would you need ( ) ?

Thanks

[FavianTubeX]

When would you use this instead of case / end statement

[JoeG]

great video. I have a question. Would you be able to do a video on Dynamic Matrices in SSRS? you have a tutorial on your website and I followed it, but i'm getting errors when running the report. i have a requirement to create a report like this, but cant seem to find any documentation online and your link below is the only one that has anything on the subject.