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