SQL Server Programming Part 12 - Cursors

[@alexchau9454]

These are the best free tutorials I have ever seen hands down. Amazing education, thank you!

[@S2100211]

Another very good video explaining something that is quite complicated. My SQL understanding and knowledge of SQL has improved 100% since I started watching this set of videos. A million thanks for all your hard work in making this look easy.

[@WiseOwlTutorials]

You are very welcome indeed! Very happy to hear that you found it useful and thanks for taking the time to leave us a comment, it's much appreciated!

[@samadoonhersi]

Better than what they teach us in University, you are amazing!

[@MegaDixen]

Universitys teachers 70% time suck as

[@gouthamakta2063]

great tutorials with excellent teaching skills. Appreciate your effort for making these video. same comment goes to all videos in this series. God bless you sir.

[@aw1789]

You're a great teacher who is definitely doing what you were born to do. I don't know where I'd be without your videos. Thanks a lot!

[@BijouBakson]

that's a lot of information in less than 30 minutes. Great thing we can play it on repeat.

[@WiseOwlTutorials]

Thanks!

[@mistery4437]

I never thought teaching can be so compelling. Absolutely riveting. Thanks Andy.

[@BoazNahumPlus]

Fantastic presentation. Very clear and well edited.

[@WiseOwlTutorials]

Thanks for watching!

[@houstonfirefox]

Very well done! The Relative Operations come in handy for stepping through Year Quarters of a project I'm working on now. Bravo!

[@WiseOwlTutorials]

Happy to hear that you found it useful, thanks for watching!

[@DukensteinA1]

This is one of the best tutorials I’ve seen.

[@WiseOwlTutorials]

Thanks! Appreciate the comment and thanks for watching!

[@ThatOneRightThere]

Such a well done video, made learning Cursor processors and when to use them so much easier than shifting through documentation online. Definitely going to check out other tutorials by WiseOwl.

[@WiseOwlTutorials]

Thank you so much Jacob, happy to hear that you found it useful and thank you for taking the time to add a comment!

[@ezekieltorres3798]

Brilliantly concise material. Thank you for the guide.

[@WiseOwlTutorials]

Thank you!

[@Fifwayte]

Very nice video even 10 years later, thank you

[@WiseOwlTutorials]

Glad you liked it, thanks for watching!

[@dmnreddy]

Too good, Thank you so much for your dedication towards the presentations.

[@BRelding92]

Hi Andy, these videos are "super dope". Really well explained and very easy to understand. I'm currently doing an MSCA and think I will be using your videos extensively. Cheers!

[@digitalbruno1]

Wonder if anyone else feels that Andrew sounds a lot like Sir David Attenborough. Only this is a SQL 'documentary' if you will ;) Thank you very much for these videos Andrew. Very educating and so easy to understand. I got my job learning SSRS by viewing your videos. Much respect to you.

[@digitalbruno1]

Thank you Andrew. I got this job from watching your videos and learning SQL and SSRS within about a week. I've also recommended your channel to a lot of my friends in India, here in Canada and the US. We're all very grateful to you for passing on this knowledge and wish you all the best. Thanks again!

[@alireza2295]

Thanks mate for making such useful and easy-to-understand videos. I am thinking of sharing my experience with our managers to see if they are willing to arrange an on-site training for our analysts within the organisation.

[@krismaly]

Good examples of curser usage. I enjoyed the video. I suggest people watch this video. Thanks

[@MicheleStrom]

For anyone following along with the video and using the Movies database that's linked above, note that you won't have the FilmCumulativeOscars column in your tblFilms table, you'll need to add it in.

[@S2100211]

Thanks for this update. I thought I had done something wrong again when I couldn't find the field.

[@MicheleStrom]

@@S2100211 HTH

[@EEldred505]

Very helpful, really appreciate your videos. They are easy to understand and I always learn what I am looking for.

[@MicheleStrom]

Thanks Andrew! This is a great video series.

[@hildesong817]

Thanks for the tutorial!

[@WiseOwlTutorials]

You're very welcome Hilde!

[@gospodintanev6783]

That voice and pronunciation!!! You are the voice in the listening part of the ESOL exam aren't you ?!

[@masegosetshogwe3513]

Really Amazing Tutorials ,we appreciate your help a whole lot.

[@Justme7888]

much much better then what they teach us at mi university,thanks!!!

[@suvradeepbanerjee6801]

The 16 dislikes are from trojan horses sitting on Host's desktop. Great tutorial as always thanks!

[@WiseOwlTutorials]

😀

[@EnduranceT]

Hands down best SQL Server tutorials on KZbin and probably the net. There are poor fools paying a lot of money for INFERIOR training to this. Glad I'm not one of them :)

[@moisescuca6112]

Excelent tutorial, so useful

[@TheQciap]

Andrew, what you do here is amazing! :D It is really understandable even for the guy like me who is not native. But there one more thing you could do to make it even more fantastic. :) Simply to provide us - students your database to practice with short video what you attach it to our SQL Server. For us the most important is simply practice, practice and one more time, watching video is not enough. If there is an option like it here forgive me as I am still the beginner in this field (but with great passion) Best regards man!!!

[@GaryHutsonVBA]

Sorry Andrew. The link was hiding since the changes to KZbin's interface. I have now found the files. Great job!

[@SpoolinMP5]

Amazing, thank you very much. They way its constructed helped a lot.

[@jonathanlusby4213]

Exactly what I needed. Thank you.

[@andremyszko]

thank u so much WiseOwl!

[@karolames1]

The video is absolutely great!

[@chamelion1red]

Very nice And Useful.......go gr8 bro

[@jackroark6928]

Out of all of you who have commented such nice things as "amazing", "easy to understand", "riveting". "super dope", "excellent", "superb", "Very helpful", "really appreciate", "better than college/university", "absolutely great", "best free tutorials", "helped me get a job", etc., etc....How many of you have donated at least $1.00 using the link in the description? :-)

[@marcin2x4]

13:07 - why the FETCH NEXT FROM is nested in the BEGIN/END block instead of being outside? So not having that instruction at line 27 will create infinite loop?

[@I677000]

Could you make tutorial about Index, with explanation of reasons to use, how to create and how to maintain them?

[@eduardokeane]

thanks Sir, greetings from Perú.

[@thetruth6900]

Amazing work, thank you !

[@MuhammadKhankhan]

you are awesome MR.

[@TheRealMrPants]

Great video! In the while loop syntax, why is correct to use SET @TotalOscars+=@FilmOscars rather than just SET @TotalOscars+@FilmOscars Also, maybe you have one and I haven't seen it, but do you plan a video on FOR XML and working with XML in SQL Server? Thanks!!

[@mnewmark2855]

***** As a SQL Server/TSQL novice I find your videos incredibly helpful and done with excellent clarity and pace. Thank you for making them available!

[@firozahmad5860]

Really appreciate what you are doing for educating us. From where can I get databases to practice on? Thanks

[@Derowik]

Thank you Andrew.This lessons and your VBA course explain programming very well. One question , with your last example I'm getting error: "invalid column name FilmCumulativeOscars"

[@ankitagurav284]

hiii sir u r vedio is superb thank a lot

[@rcasturi55]

Great instruction. Thanks .

[@lb794]

great video! You are very good at explaining. Question, how would you do a nested cursor and when is it really necessary?

[@puurusottamsaha8971]

very nice sir..!! speechless..!

[@cheathack]

Great tutorial!

[@armanwirawan7099]

I have a question regarding the print @filename + ‘was released on ‘ + CCONVERT(char(10), filmdate,103) 1. How did sql knows to put jn filmid in convert(char(10)) 2. What does the 103 at the end means why dis you put it there? Thank you

[@WiseOwlTutorials]

Hi Arman! We have a video on working with dates which explains how it works here kzbin.info/www/bejne/h2PbmXSXm9WFgNE You can see the full list of date format codes here learn.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql?view=sql-server-ver16 I hope it helps!

[@romanvidrevich9973]

I am trying to wrap my head around why @@fetch_status= 0, would result in a true response from the server instead of 1. Could you please elaborate? Thank You

[@damiancollier5051]

Impressive tutorials. With cursors, why are scroll and forward only used? Why not just leave it as cursor with all fetch options available?

[@jens3737]

Thank you wise owl

[@kylearnold4491]

What program setup do people use to program SQL code like this? I have MySQL with XAMPP apache server and the two database languages conflict to where the syntax is always wrong. Really frustrating trying to learn from these tutorials and have MySQL constantly telling me I'm wrong.

[@selvadav]

Awesome sir, can you present it for Triggers.?

[@arghyanandy6469]

'Specifies that the membership and order of rows in the cursor are fixed when the cursor is opened.' what does the word 'membership' from the above sentence refers to?

[@WiseOwlTutorials]

Hi Arghya, "membership" in this context means that the rows exist in or belong to the cursor. i hope that helps!

[@AshfaaqCurimbaccus]

the best !

[@alaaabdelnabi6088]

thanks for wonderful tutorial m, How i can use "Wildcard" in selecting statment for the crusor ???

[@raidibelo973]

Thank You So much

[@JoeG2324]

really nice video on cursors. I had a question. On your website, I saw a lot of excel vba videos. Could you do some youtube videos on excel vba?

[@java1370]

Very Good

[@arbteampraetorians3452]

tnks a lot dude

[@eduardokeane]

Yes, triggers please!

[@crypticparadigm2180]

This is nice, but the implementation yields a duplicate on the last loop.

[@YesYou123333]

Why do you need two fetch statements?

[@samirhasanov7894]

first is right after the opening. second one to keep fetching on.

[@DannTeBg]

the volume is super low

[@motamendez]

man thanks

[@007kash007]

sounds like tony blair

[@xuepengliao9002]

bookmark 06:05

[@johnnynephrite6147]

"Completely differently", really?

[@pariuripecartonase9464]

Amazing work, thanks

[@WiseOwlTutorials]

You're welcome, thanks for watching!