SQL Server Programming Part 6 – WHILE Loops

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

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

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

Good one.

I know ur a brit but ur english is terrible for a global audience. Im american n i cant tell what ur tryin to say dude. Asians make better sense than u

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

wich two films won 11 oscar?? :O

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

HI i have a problem in sql wherein i want to update column value between 10 and 20, there are 100 rows and just want to update next columns between 10 and 20
can you help me how to figure it out

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.

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
print cast(@numberFilms as varchar(3)) + ' Films have ' + Cast(@count as varchar(2)) + ' Oscars'
end

a very good video. clear explanations .rock on

Hi there,

Enjoying and learning from the video, however, when I downloaded the updated db from the link in the info, running the code in SSMS didn't work and I had to modify the code to get it to work. Below is the code I used

DECLARE @Counter INT
DECLARE @MaxFilmOscarWins INT
DECLARE @NumFilms INT

SET @MaxFilmOscarWins = (SELECT MAX(FilmOscarWins) FROM [dbo].[tblFilm])
SET @Counter = 0

WHILE @Counter<=@MaxFilmOscarWins
BEGIN
SET @NumFilms =
(SELECT COUNT (*) FROM tblFilm WHERE FilmOscarWins = @Counter)

PRINT CAST(@NumFilms AS VARCHAR(3)) + ' films have won ' +
CAST(@Counter AS VARCHAR(2)) + ' Oscars. '

SET @Counter = @Counter + 1
END

Hope this helps.

Mike

THANKS BRO …. saved me from a big problem!

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

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

thanks man!

hello,
sorry to bother you, but im asking is this how we automate a stored procedure to run automaticlly, it is not working:

use master
go
CREATE PROCEDURE MyBackgroundTask
AS
BEGIN
    — SET NOCOUNT ON added to prevent extra result sets from
    — interfering with SELECT statements.
    SET NOCOUNT ON;

    — The interval between cleanup attempts
    declare @timeToRun nvarchar(50)
    set @timeToRun= '03:33:33'

    while 1 = 1
    begin
        waitfor time @timeToRun
        begin
            execute [MyDatabaseName].[dbo].[MyDatabaseStoredProcedure];
        end
    end
END

————

sp_procoption    @ProcName= 'MyBackgroundTask',
               @OptionName= 'startup',
               @OptionValue= 'on'

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.

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.

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?? 

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

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

Good introduction of CURSORS. I enjoyed the video. Thanks

Thanks – you're tutorials are awesome!