SQL Server Programming Part 6 - WHILE Loops

By Andrew Gould

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:

[juanisidrodiaz]

More than 10 years and still a master of piece with a clear concept and explanation. Thanks a lot.

[mistery]

Your rhetoric is lucid, controlled, non-persuasive and engrossing. A Masterclass. Thanks, Again.

[marcjohnson]

One of the clearest explanations I've seen. Well done.

[koporcic]

I needed to learn store procedures, then I was needing everything in this tutorial in this exact order... you deserve the subscribe!

[m.a.saberi]

your teaching skill is perfect and your accent is very clear and cute.

[michaelo]

Great tutorial! You sound like a wise owl :) It's very pleasant to the ears.

[estuardojuchuna]

THANKS BRO .... saved me from a big problem!

[krismaly]

Good introduction of CURSORS. I enjoyed the video. Thanks

[RayanJawad]

Thanks - you're tutorials are awesome!

[CNich]

First things first, this is by far the best course on stored procedures I have come across. So thank you so much! I have a question in regards to the use of the global variables; what if multiple store procedures are running at the same time? Would they interfere with each other when referencing the global variables?

[mehmethuseyinozcan]

Thanks you are the best .... Guys! other way for better solution for seeing 0 film 9 and 10 oscars line
set @numberFilms = (select COUNT(*) from tblFilm f where f.FilmOscarWins = @count)
if @numberFilms != 0
begin
end

[shahimkhlaifat]

Yours are very very helpful thank you, but you might ignore the 'print statement' and go for sql database and show the loop in manipulating the data instead. most of the people are not looking to print messages in sql.

[gildewinter]

a very good video. clear explanations .rock on

[piyushsikka]

Thank you !
you videos are very helpful !
could you please tell me how to go through all rows of one column and print them using loop

[lbisu]

Very good videos with clear didactic style. I am a highly experienced Oracle pl/sql programmer who wants to have the skill level to convert to a t-sql programmer since my current employability is bit limited. What experience to you have with Oracle developers becoming t-sql/SQL Server programmers in terms of required effort and success rate in finding SQL Server roles? Thx.

[BenChi]

Thank you for your very helpful walk-throughs! What software do you use to make your screen capture videos?

[adifrenkenberg]

why did you define the films oscar wins as 'MAX'? Wouldn't it work the same without it?

[xwan]

Really awl some, I just have a question about the "if ……break" clause, according to the result, the result set will be truncated if @NumFilms=0, but the result for the films that won 11 Oscars is truncated at the same time! We just want to delete the @NumFilms=0 result.  How to solve it?? 

[hardbrocklife]

I thought I was going to have to learn Hindi to learn anything about sql lol. Jk...but still.

[Hjominbonrun]

This is a good video showing how it works, but you need to start the video stating clearly that a while loop, recursive CTE's and cursors must be done as last resort and only if you have convinced the DBA that there is absolutely no other way.