+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.
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'
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
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!
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, 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?
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!
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
Pointer to resultset, this is the most important thing, that explains cursors to a programmer at once. Thanks for the video.
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.
This video was very helpful for me and it's very neat and organized. Thank you so much!!!
Your videos have always been my "go to" resource for SQL
Thank you very much, amazing explanation as always!
Very good explanation sir. Thank you very much for sharing your knowledge!
Great explanation of Cursors! I appreciate this.
Thank you for sharing! This video is very helpful for my work!
Thank you for this brilliant course on sql,you are life saver .
U are a great teacher ..
Great Explanation , Your videos are very useful . Thanks
Great job at explaining cursors!!
Thanks Venkat .You are the man. Looking forward to more insightful tutorials from you .And please talk about the execution plans .Cheers
Another great video by Venkat!
Great simple and easy to understand video about cursors. Keep up the great work my friend!
after very long of search find a useful video for cursor .
Thank you sir! I have watched all the videos in this list and I look forward to your new videos.
This really helped, thank you.
Thanks for the lesson, it really helped with my project. Much appreciated!
Thanks for your knowledge sharing.. thanks a lot sir
Thank you so much for your efforts for us.
brilliant and a clear guide, thank you for this
god bless this man
well explained!!
Very good job brother..I am following all of your videos..please keep doing this.
Sure, Anurag, will do it as soon as I can.
u're the best thanks
Excellent tutorial, thank you 👍
Great Lecture simply you are Best that's it sir
Great teaching, indeed
Excellent explaination! Thank you!!
Thanks for the Videos, it's Awesome :D
Hi Sir, Your videos and way of expressing it is really awesome..Please kindly give videos on dynamic SQL ..
Hi Jason, I almost forgot about it. Yet to record. Thanks for reminding. Will do it as soon as I can.
very clear! thanks a lot =)
Thank you very much very good explanation .
You are amazing man.. Why weren't you available in my Uni :).
This sort of stuff makes RUclips proud. Keep it up
Thank you very much sir ❤
Very good one Venkat...
Thank you sir..for giving us good concept
HELLO Sir
Your videos are very beneficial for freshers....
M alwys watching ur videos and recommended to all my frndzzz....
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
Great job
thank u !!!
Awesome job...Keep it up bro!!!
Thank you
Nice explanation thanks...
GOOD EXPLAINATION
good job. thank you.
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!
you are awesome sir
Sir what is difference between cursor and while loop, why we use while inspite of using cursor.
great video... why two times fetch statement?
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.
thanx man .i learned a lot of things . thnxxxxxxxxxxxxxxxx a lot
Well explained
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
Thank you sir.. sir, what is scroll keyword sometimes seen in declare statement???
really great
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?
Hi Venkat,
Can you please add a video for differences between cursor types
wow, 8 years ago man!!!
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?
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.
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..
Sir very nice tutorial, can we download the database for practice please?
Hi Sir Please Upload video on collation.
can we use select statement in while loop ? i was asked this question in sql developer interview
Yes we can use it.
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
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.
where is the data again??some times you have it
Hello plz help me, I'm getting unknown system variable @@FETCH_STATUS. HOW TO RESOLOVE DIS??
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
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
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 :)
The red pulsing cursor is annoying. Simply use RED color cursor instead.
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 tutorial! Thank you!