+Rani Kala Thank you so much for the feedback. Means a lot. Glad the videos are useful. Dot Net & SQL Server training videos for aspiring web developers ruclips.net/user/kudvenkatplaylists?view=1&sort=dd Download our training videos and slides for offline viewing www.pragimtech.com/Order.aspx Code Samples, Text Version of the videos & PPTS on my blog csharp-video-tutorials.blogspot.com Tips to best utilise our channel ruclips.net/video/y780MwhY70s/видео.html To receive email alerts, when new videos are uploaded, please subscribe to our channel using the link below ruclips.net/user/kudvenkat Please click the THUMBS UP button below the video, if you think you liked them Thank you for sharing the link with your friends who you think would also benefit from them Best Venkat
i am chinese ,i come from china. i have not been to any other country. i just like to use vpn to visit google or youtube ,studying some technology. our chinese people said ,proctect my country ,Not allowed to use vpn. our teachers can not teach like these videos which are very useful and very clearly. i am sad, and maybe in the next hour,i can not visit youtube.
Great difficult code, but it works. I'm going fast to the next video session. U are great teacher. I've improved new skills thankx to U. Greetings from Poland.
Dear Venkat..awesome work really...but can you upload oracle sql and plsql...!!!you are uploading just microsoft server concepts..but we need oracle concepts as well please...thanks
I know it's been a long time since your SQL Server videos 63 and 64 were published, but I was wondering how I would go about coding the original cursor example in video 63 (printing the product id and product name for the rows in the database) using a set-based/joins approach instead of a cursor.
Hi. Nice videos. Could u upload video about "execution plan" in sql server. If already it is uploaded plz send me the link. I watched almost all videos but I did not found. Thank u
Hi Venkat, your explanation is awesome! I have a quick question, in the previous video you said you would talk about how to read the execution plans etc., but the topic of this video is obviously different, so is it that you have not made that video yet or that you have not uploaded it on youtube yet? Thank you!
Hi Venkat, Let's say I have a table containing 100k rows and sometimes I need to delete 10k rows at a time using their id. From c# I can pass the list of ids or I can call a delete store proc with id parameter that will delete row one by one. Is there any better way to perform something like bulk delete with high performance?
Thank you very much for taking time to give feedback. I upload training videos on a daily basis. If you want to receive email alerts when new videos are uploaded, please feel free to subscribe to my youtube channel.
hi sir,I have a doubt.plz clarify my doubt. In column data that contains data like country(SL001) like this data is stored bt now I want only country I don't want code which contains in braces for multiple record which code contain 'SL'
Question: Everywhere they say not to use Cursor as it causes high compilation time and parse of the fetch statements and also there are other quicker ways to obtain same results using joins. Then, why is Cursor an option for querying in SQL server? Is there any specific reason to only use Cursor for any particular query? Will appreciate anyone who clarify this for me. :)
Because SQL is designed for Set Base operations and not for looping, the cursor should be deprecated but it remains because more than likely bad programmers will go ape shit. I have never needed to use one.
How can I use cursor to insert record from one table to another and then mark the existing record as duplicate in previous table...can anybody guide me
great.thank you.clear,simple code
+Rani Kala Thank you so much for the feedback. Means a lot. Glad the videos are useful.
Dot Net & SQL Server training videos for aspiring web developers
ruclips.net/user/kudvenkatplaylists?view=1&sort=dd
Download our training videos and slides for offline viewing
www.pragimtech.com/Order.aspx
Code Samples, Text Version of the videos & PPTS on my blog
csharp-video-tutorials.blogspot.com
Tips to best utilise our channel
ruclips.net/video/y780MwhY70s/видео.html
To receive email alerts, when new videos are uploaded, please subscribe to our channel using the link below
ruclips.net/user/kudvenkat
Please click the THUMBS UP button below the video, if you think you liked them
Thank you for sharing the link with your friends who you think would also benefit from them
Best
Venkat
i am chinese ,i come from china. i have not been to any other country.
i just like to use vpn to visit google or youtube ,studying some technology.
our chinese people said ,proctect my country ,Not allowed to use vpn.
our teachers can not teach like these videos which are very useful and very clearly.
i am sad, and maybe in the next hour,i can not visit youtube.
You're an excellent teacher. I only watch your videos now and I subscribed! keep it up!
Pointer to resultset, this is the most important thing, that explains cursors to a programmer at once. Thanks for the video.
Thank you very much, amazing explanation as always!
This video was very helpful for me and it's very neat and organized. Thank you so much!!!
Great difficult code, but it works. I'm going fast to the next video session. U are great teacher. I've improved new skills thankx to U. Greetings from Poland.
Great explanation of Cursors! I appreciate this.
Great job at explaining cursors!!
Thank you for sharing! This video is very helpful for my work!
Your videos have always been my "go to" resource for SQL
Great Explanation , Your videos are very useful . Thanks
Thank you for this brilliant course on sql,you are life saver .
after very long of search find a useful video for cursor .
Thanks Venkat .You are the man. Looking forward to more insightful tutorials from you .And please talk about the execution plans .Cheers
U are a great teacher ..
Great simple and easy to understand video about cursors. Keep up the great work my friend!
Another great video by Venkat!
This really helped, thank you.
Thanks for your knowledge sharing.. thanks a lot sir
Thanks for the lesson, it really helped with my project. Much appreciated!
Thank you sir! I have watched all the videos in this list and I look forward to your new videos.
Hi Sir, Your videos and way of expressing it is really awesome..Please kindly give videos on dynamic SQL ..
Great Lecture simply you are Best that's it sir
Dear Venkat..awesome work really...but can you upload oracle sql and plsql...!!!you are uploading just microsoft server concepts..but we need oracle concepts as well please...thanks
HELLO Sir
Your videos are very beneficial for freshers....
M alwys watching ur videos and recommended to all my frndzzz....
brilliant and a clear guide, thank you for this
Thank you so much for your efforts for us.
Excellent tutorial, thank you 👍
Excellent tutorial! Thank you!
Very good job brother..I am following all of your videos..please keep doing this.
Thank you very much very good explanation .
god bless this man
Great teaching, indeed
Hi Jason, I almost forgot about it. Yet to record. Thanks for reminding. Will do it as soon as I can.
Thank you sir..for giving us good concept
Very good one Venkat...
Thanks for the Videos, it's Awesome :D
Sure, Anurag, will do it as soon as I can.
u're the best thanks
You are amazing man.. Why weren't you available in my Uni :).
This sort of stuff makes RUclips proud. Keep it up
I know it's been a long time since your SQL Server videos 63 and 64 were published, but I was wondering how I would go about coding the original cursor example in video 63 (printing the product id and product name for the rows in the database) using a set-based/joins approach instead of a cursor.
very clear! thanks a lot =)
Thank you very much sir ❤
Hi. Nice videos. Could u upload video about "execution plan" in sql server. If already it is uploaded plz send me the link. I watched almost all videos but I did not found. Thank u
Great job
Sir what is difference between cursor and while loop, why we use while inspite of using cursor.
Nice explanation thanks...
Awesome job...Keep it up bro!!!
Hi Venkat, your explanation is awesome! I have a quick question, in the previous video you said you would talk about how to read the execution plans etc., but the topic of this video is obviously different, so is it that you have not made that video yet or that you have not uploaded it on youtube yet? Thank you!
well explained!!
thank u !!!
Thank you sir.. sir, what is scroll keyword sometimes seen in declare statement???
GOOD EXPLAINATION
Hi Venkat,
Can you please add a video for differences between cursor types
wow, 8 years ago man!!!
Okay since it's advised to write set based queries in SQL, why ever use a cursor? When will I need a row by row query?
good job. thank you.
great video... why two times fetch statement?
Hi Venkat, Let's say I have a table containing 100k rows and sometimes I need to delete 10k rows at a time using their id. From c# I can pass the list of ids or I can call a delete store proc with id parameter that will delete row one by one. Is there any better way to perform something like bulk delete with high performance?
Thank you
you are awesome sir
Sir very nice tutorial, can we download the database for practice please?
great video. I don't get how outer cursor is looping row by row, when there is no while loop?
Outer cursor isn't looping it is just getting into table by 'FETCH NEXT', through it control is getting into the inner while loop.
Thank you very much for taking time to give feedback. I upload training videos on a daily basis. If you want to receive email alerts when new videos are uploaded, please feel free to subscribe to my youtube channel.
hi sir,I have a doubt.plz clarify my doubt. In column data that contains data like country(SL001) like this data is stored bt now I want only country I don't want code which contains in braces for multiple record which code contain 'SL'
how to write a query for that to update all the records at a time
Well explained
Hi Sir Please Upload video on collation.
thanx man .i learned a lot of things . thnxxxxxxxxxxxxxxxx a lot
Question: Everywhere they say not to use Cursor as it causes high compilation time and parse of the fetch statements and also there are other quicker ways to obtain same results using joins. Then, why is Cursor an option for querying in SQL server? Is there any specific reason to only use Cursor for any particular query? Will appreciate anyone who clarify this for me. :)
Because SQL is designed for Set Base operations and not for looping, the cursor should be deprecated but it remains because more than likely bad programmers will go ape shit. I have never needed to use one.
really great
Hello venkat,
I want to learn pl/sql programming from you. Could u please tell me how I can contact you?
Thank you
Contact his institution Pragim Technologies at www.pragimtech.com
hi venkat
can u explain if...exists....in stored procedure
and how to send mails regarding events before 3 working days.Events are in database..
can we use select statement in while loop ? i was asked this question in sql developer interview
Yes we can use it.
It is not displaying anything it is just writing commands completed sucessfully. It is not displaying the result in your first query.
sir plz can u make one demo tool for migrating data from ms sql to oracle
Hello plz help me, I'm getting unknown system variable @@FETCH_STATUS. HOW TO RESOLOVE DIS??
The red pulsing cursor is annoying. Simply use RED color cursor instead.
Please Can You Share The Video How to download and Install SSMS. I was download Many Times But It Was Not Work
ruclips.net/video/yasfZuou3zI/видео.html
follow this link and watch the video :)
How can I use cursor to insert record from one table to another and then mark the existing record as duplicate in previous table...can anybody guide me
where is the data again??some times you have it
Do we have any replacement of bulk collect and fetchall in sql server as I don't want to have a loop for each record.
Excellent explaination! Thank you!!