Stored procedures in sql server Part 18

Поділитися
Вставка
  • Опубліковано 3 тра 2024
  • In this video we will learn
    1. What is a stored procedure
    2. Stored Procedure example
    3. Creating a stored procedure with parameters
    4. Altering SP
    5. Viewing the text of the SP
    6. Dropping the SP
    7. Encrypting stored procedure
    Text version of the video
    csharp-video-tutorials.blogspo...
    Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our UA-cam channel. Hope you can help.
    / @aarvikitchen5572
    Slides
    csharp-video-tutorials.blogspo...
    All SQL Server Text Articles
    csharp-video-tutorials.blogspo...
    All SQL Server Slides
    csharp-video-tutorials.blogspo...
    All Dot Net and SQL Server Tutorials in English
    ua-cam.com/users/kudvenka...
    All Dot Net and SQL Server Tutorials in Arabic
    / kudvenkatarabic

КОМЕНТАРІ • 462

  • @gauravtaori498
    @gauravtaori498 7 років тому +104

    excellent. you are just fab

    • @Csharp-video-tutorialsBlogspot
      @Csharp-video-tutorialsBlogspot  7 років тому +22

      Thank you very much for taking time to give feedback. This means a lot. I am very glad you found the videos useful.
      I have organised all the Dot Net & SQL Server videos in to playlists, which could be useful to you
      ua-cam.com/users/kudvenkatplaylists?view=1&sort=dd
      If you need DVDs or to download all the videos for offline viewing please visit
      www.pragimtech.com/order.aspx
      Slides and Text Version of the videos can be found on my blog
      csharp-video-tutorials.blogspot.com
      Tips to effectively use my youtube channel.
      ua-cam.com/video/y780MwhY70s/v-deo.html
      If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel.
      ua-cam.com/users/kudvenkat
      If you like these videos, please click on the THUMBS UP button below the video.
      May I ask you for a favor. I want these tutorials to be helpful for as many people as possible. Please share the link with your friends and family who you think would also benefit from them.
      Good Luck
      Venkat

  • @recipetest
    @recipetest 6 років тому +27

    You are legend. I even let the ads play fully so at least I can do something for you!

  • @kayongojohnsonbrian3902
    @kayongojohnsonbrian3902 3 роки тому +24

    woooow .. eight years down the road and i am finding this video wonderful,,,.. thanks for saving me

  • @T2Mful
    @T2Mful Рік тому +13

    10 years after and still very useful. Thanks for your effort and time

  • @natavesta2010
    @natavesta2010 5 років тому +19

    I am learning SQL-server from the different resources. But I can say for sure: your videos are the best in terms of clear and complete explanation of ANY subject! Every word is valuable - nothing to add, nothing to subtract. Just perfect!

  • @Trzbne
    @Trzbne 6 років тому +26

    Another masterpiece of this channel. Slowly but surely I say goodbye to the fear at the beginning of learning something new. Learning makes me happy but I always was scared, that I will not be enough, I can not comprehend, I will be slow. After your lessons I feel: Wow, I understand it! Wow, it works on my computer, too! Wow, that was easier than I thought!
    Thank you from the bottom of my heart for kindly forcing this old fear to disappear.

  • @LakmalHckz
    @LakmalHckz 6 років тому +13

    When i'm searching for something, if there's a your tutorial, i know that i don't want to worry about it anymore :)
    Thanks. Keep it up!

  • @user-vm6fn2kg8z
    @user-vm6fn2kg8z 7 років тому +63

    this man is a LEGEND!!

  • @rachhpalkaur2512
    @rachhpalkaur2512 3 роки тому +1

    Thank you so much. your teaching skills are superb. I have not technical background but i learnt a lot from these videos. Best tutorials

  • @hollygrigsby3038
    @hollygrigsby3038 2 місяці тому

    Very good! Love the pace and the method you use. VERY helpful as a refresher even after over a decade of working with SQL Server!

  • @krzysztofs8535
    @krzysztofs8535 7 років тому +2

    You are master of SQL. Thank you for sharing these videos. Greetings from Poland!

  • @robbinsethi7476
    @robbinsethi7476 Рік тому +1

    Earlier I would find this concept to be very confusing but you explained it amazingly well. Very useful. Thanks a lot!

  • @krishjotsarai425
    @krishjotsarai425 7 місяців тому +1

    You are one of the best teachers I ever had. Thank you very much. subscribed!!!

  • @SonuKumarTech
    @SonuKumarTech Місяць тому

    I watched your full tutorial on dotnet and react courses 5 years ago and I had some issues recently in the database so searched on UA-cam and suddenly your 10 years old video came up on indexing and I was surprised that how I missed your tutorial on SQL. You are just awesome.

  • @miguelmont4576
    @miguelmont4576 5 років тому +9

    I learned more with your tutorials from what I learned in my database class at my university

  • @nazakatali3778
    @nazakatali3778 Рік тому +1

    Hi Venkat, you made SQL so easy for us, I usually don't comment on Videos, but your way of elaborating things made me praise your content, Many thanks🤝

  • @abrahammahmoudi7470
    @abrahammahmoudi7470 2 роки тому

    Like all other parts, you perfectly explain the things, I love your way of training!

  • @socerboy06
    @socerboy06 9 років тому +43

    Best SQL Sever tutorial I've seen.

    • @krismaly
      @krismaly 9 років тому +9

      You are right.
      Spread the word to your friends

  • @sandeepbisht4057
    @sandeepbisht4057 3 роки тому

    You are best 🙏..No body can teach SQL better than u...many people become DBA just bcz of your videos.
    Respect for u Sir 🙏

  • @leonvieira3877
    @leonvieira3877 3 роки тому

    Short concise and gets the point across Cleary I love it.

  • @HAMZA-he9nd
    @HAMZA-he9nd 8 років тому

    Your teaching style is very clear and impressive!! Thanks for the video

  • @shwetaaswal3383
    @shwetaaswal3383 9 місяців тому +1

    amazing!! Love the way you teach these topics.

  • @Csharp-video-tutorialsBlogspot
    @Csharp-video-tutorialsBlogspot  11 років тому +49

    Thank you very much for the feedback. I have included the link for the complete sql server playlist in the description of this video. This playlist contains all the videos in a logical sequence. Hope, you will find it useful. Good Luck

  • @babzo1
    @babzo1 10 років тому +1

    Always refreshing..
    Thanks Venkat

  • @raghavprasad277
    @raghavprasad277 3 роки тому

    Thank you Venkat. Your SQL tutorials are clear and concise.

  • @abhishekbadge5359
    @abhishekbadge5359 Рік тому

    Hi the way you explained is totally magical and your voice is so calm and captivating…thanks for the SQL playlist

  • @naregtokatlian3663
    @naregtokatlian3663 5 років тому +4

    i'm a student and i watch your tutorials every time i struggle with something, and i always understand everything at the end of an each video. you're teaching skills are amazing , i'm sure there are a lot of people so grateful to you as i am . thank you very much sir (i can't thank you enough ) .

  • @AdisonPenaMartinez
    @AdisonPenaMartinez 11 років тому +1

    Incredibly helpful. All your videos are accurate and concise, hence easy to understand :)
    Thank you a lot.!

  • @chrispang4035
    @chrispang4035 5 років тому

    Thank you! This was extremely helpful & easy to follow.

  • @kalyanp7857
    @kalyanp7857 8 років тому

    you are extensively awesome, I have completed my bachelors and masters in electrical. I just switch to computers with out knowledge.So i have chosen my inception would be ETL AND SQL, know i am master in SQL AND IMFORMATICA Cause 'that is your videos', even Informatica behind the scenes were based on SQL i realize.
    Massive THANKS for you.

  • @Hopefulnezz
    @Hopefulnezz Рік тому +1

    You always deliver with your way of teaching! Thank you for sharing your knowledge 👏👏👏

  • @erassy5278
    @erassy5278 6 років тому +1

    Thank you for sharing,
    This tutorial is even way better than my lectures that i get in Advanced Databases module.

  • @KedWebDev2011
    @KedWebDev2011 9 років тому

    Great job Venkat! I did not know you could encrypt the text of stored procedures. Very helpful and informative!

  • @sunithareddyd22
    @sunithareddyd22 6 років тому

    Excellent ..very very useful to everyone...plz follow this u became SQL expert..Thank u so much

  • @uNKNOWNsINGER8874
    @uNKNOWNsINGER8874 Рік тому

    Sir your stoted procedure video is awesome ever i am seeing this video in 2022 after 10 years of your creation i just got goosebumps👍👍❤️

  • @YaseenKhan-xm9dx
    @YaseenKhan-xm9dx 7 років тому +3

    Best video on stored procedures. EXCELLENT!!!

  • @supa.scoopa
    @supa.scoopa 3 місяці тому

    Omg I will keep up to date with your channel, it's a gem. Just perfect. Thank you so much.

  • @raghuanamala1125
    @raghuanamala1125 2 роки тому

    Sir, your way of explanation is really good to understand. Thanks for the free learning platform.

  • @rohitsupa
    @rohitsupa 8 років тому +8

    some of the best tutorial on STORED PROC

  • @edwardjacob4098
    @edwardjacob4098 3 роки тому

    You are the best, Venkat.

  • @golammuhaimeen2825
    @golammuhaimeen2825 2 роки тому +1

    excellent explanation video! really helped me out. Thank you!

  • @thelonewolf9866
    @thelonewolf9866 3 роки тому +1

    Just want to tell @kudvenkat that these tutorials are still much appreciated to this day (currently 2020-12-29)

  • @OK-dy8tr
    @OK-dy8tr 2 роки тому

    This is explained is such a simple way. This is still relevant after 9 years !

  • @YT_Master3488
    @YT_Master3488 2 роки тому

    You are the best. Best video for learning SQL.
    Thank you so much for such content.

  • @SatishDangol
    @SatishDangol 6 років тому

    Great Guru, Thank you so much for your hard work and we really appreciate. Best of Luck.

  • @Cinematic-Frenzy
    @Cinematic-Frenzy 2 роки тому

    9yrs down the line and you still the best

  • @kavithavishwanathen6778
    @kavithavishwanathen6778 6 років тому

    your videos made me enter programming world and later to enter it company as junior to senior software programmer.....u made my dream come true but still as a student i have a request plz do videos on stored procedures ,scripts in detail.........thanks a lot for immmens knowledge....truely grateful

  • @nikhilmdkr
    @nikhilmdkr 2 роки тому

    CRYSTAL CLEAR EXPLANATION OF TOPIC IN ALL WAYS AND DIMENSIONS......REALLY SUPERB

  • @Accord2007
    @Accord2007 11 років тому

    really nice and informative video tutorial. i strongly recommend tutorials by Mr Venkat for those who are beginners in SQL server. Thank You .

  • @ashwinishastrakar8795
    @ashwinishastrakar8795 3 роки тому

    You explained very well..I clearly understand what are the stored procedure. Thank you🙏

  • @piyasidey2117
    @piyasidey2117 7 років тому +2

    Have no words to thank You Sir...

  • @Csharp-video-tutorialsBlogspot
    @Csharp-video-tutorialsBlogspot  10 років тому +4

    Thank you very much for taking time to give feedback. In the description of this video, I have included the link for ASP .NET, C#, and SQL Server playlists. All the videos are arranged in logical sequence in these playlists, which could be useful to you. Please share the link with your friends who you think would also benefit from them. If you like these videos, please click on the THUMBS UP button below the video. For email alerts, when new videos are uploaded, you may subscribe to my channel.

  • @rajkumarpalle8217
    @rajkumarpalle8217 Рік тому

    It was Clearly Explanation and Wonderful video . Thank you Brother.

  • @ismokepot123
    @ismokepot123 6 років тому

    thank you so much for your work, very informative tutorials for any beginner to learn! Have a good day!

  • @vik2008USA
    @vik2008USA 11 років тому

    Many Thanks to you for providing this information in a manner that is easy to understand. You are doing a very good work for others and you would be rewarded for that in other ways.

  • @anuragvashishtha6660
    @anuragvashishtha6660 11 років тому

    Great content. Great presentation. Its a treat to learn SQL through your videos.

  • @neerajadondapati4355
    @neerajadondapati4355 10 років тому

    The way of explanation and voice are very clear...thanx for all ur efforts :)

  • @meghasyam427
    @meghasyam427 6 років тому

    i am taking a break here after watching first 18 videos ...it has been really good....lot of knowledge.....

  • @luccawu1016
    @luccawu1016 8 років тому +5

    OMG! Best ever lecture regarding this topic

  • @faizyrizvi4264
    @faizyrizvi4264 8 років тому +1

    Great Job Kudvenkat ,really great explanation

  • @germanhabreu
    @germanhabreu 8 років тому +4

    hands down the best explanation on Stored Procedures
    Thanks

  • @Ayubajbnabi
    @Ayubajbnabi 10 років тому

    Excellent as usual. Thanks for the great work

  • @kirtim1930
    @kirtim1930 3 роки тому

    Thank you very much! I learned so many new things.

  • @Learngroweducate
    @Learngroweducate 4 роки тому

    Superb tutorials Nicely explained. Really appreciate. Thank you!

  • @msajidh1970
    @msajidh1970 10 років тому

    Very detail Explaination with each command step by step...
    Thanks

  • @Jazz9699
    @Jazz9699 8 років тому

    u r doing a great job!
    hats-off to u

  • @mukteshagamer5163
    @mukteshagamer5163 10 років тому

    Thank you venkat. Your's is one of the best tutorial I have encountered in youtube. It will help so many people who dont have time/money to learn new things.
    Keep up the good work .. :)

  • @ikennaezeogu1200
    @ikennaezeogu1200 2 роки тому

    Great explanations, I really learnt so much in 20 mins, thank you sir

  • @wishingW3L
    @wishingW3L 10 років тому

    very good video! Easily the best I've seen yet.

  • @thaboamos5106
    @thaboamos5106 5 років тому

    Well explained. Many thanks, and keep up the good work.

  • @harikrishnasai6104
    @harikrishnasai6104 2 роки тому

    Ur the epitome to teach sql ,TnQ so much sir

  • @martinaullah1917
    @martinaullah1917 7 років тому

    That's great video and your explanation.. Thank you very much for posting it here..

  • @rcasturi55
    @rcasturi55 4 місяці тому

    You are a great teacher Venkat

  • @AMANSINGH-yv4vv
    @AMANSINGH-yv4vv 2 роки тому

    Too much knowledge in one video . Thanks so much !!

  • @jkvelasquez84
    @jkvelasquez84 7 років тому +3

    I'm learning to write my very first stored procedure...great tutorial!

  • @mh_12rider44
    @mh_12rider44 4 роки тому

    These videos are helping me now thanks a lot for such easy learning lectures.

  • @mrsinisa11aaa
    @mrsinisa11aaa 4 роки тому

    What to say? Your tutorials are great and very helpful. Thank you 🙏

  • @debbyskitchen_by_funmi
    @debbyskitchen_by_funmi 3 роки тому

    You are amazing!!! Great teacher👏🏽👏🏽👏🏽👏🏽🙌👍🏽👍🏽

  • @momeveryday5466
    @momeveryday5466 Рік тому

    Thanks a lot Venkat ☺️😊
    This helped me a lot.... Thankyou so much

  • @osamashabbir3612
    @osamashabbir3612 4 роки тому

    You sir, are a good teacher.
    Thank you.

  • @snk2288
    @snk2288 6 років тому

    Nice tutorial on Stored Procs. Good work.

  • @7huannp
    @7huannp 6 років тому

    Thank you, sir. You used languages that so, so clearly. Anyone also understands about it.

  • @ashoksura598
    @ashoksura598 6 років тому

    u r excellent sir.. i am just beginner....but ur videos helps me alot
    really u r god sir

  • @TrangNguyen-vc5bt
    @TrangNguyen-vc5bt 2 роки тому

    You are the best teacher!

  • @factworld4375
    @factworld4375 5 років тому

    Finally I am watching this and still it's great.

  • @Csharp-video-tutorialsBlogspot
    @Csharp-video-tutorialsBlogspot  11 років тому

    Hi Rajes, Thank you very much for the feedback. All the topics you have mentioned are in my To-Do list.Will upload these videos as soon as I can.

  • @mounikapandra3879
    @mounikapandra3879 3 роки тому

    your teaching is another level...........keep rocking

  • @jeroengrrb.4360
    @jeroengrrb.4360 7 років тому +3

    This is much easier to understand than the microsoft book on quering ms sql....Thanks a lot!

    • @SantoshKumar.budithi
      @SantoshKumar.budithi 7 років тому +1

      IKR. I sometimes feel that those who makes the product sucks at preparing the guide for that.
      I think they want to make it complicated and uninteresting to the readers. They put lots of complicated wording and sentence structure.

  • @amkytube5242
    @amkytube5242 3 роки тому

    really realy you are the best one. thanks for sharing your knowledge

  • @chetansoni8512
    @chetansoni8512 2 роки тому

    Such a clear and understandable explanation. Thank you sir

  • @gss1972
    @gss1972 10 років тому +1

    Thanks for these videos, just working through them, they have been very helpful to me as i have no programming knowledge or interest, but enough information to help with my current job role installing software and not coding it :) cheers keep up good work

  • @hanumankorlepara2207
    @hanumankorlepara2207 10 років тому

    Wonderful video I have seen so far...Very nice!!!

  • @jagadeeshp568
    @jagadeeshp568 10 років тому

    Hello Venkat sir,
    very very useful..
    ur voice is very clear. it is very helpful to me.

  • @bhaveshrawat1364
    @bhaveshrawat1364 2 роки тому

    Thanks for the wonderful explanation!

  • @evangelinekiku7380
    @evangelinekiku7380 4 роки тому

    This tourial is very self explanatory. Thank you very much. I am looking forward to watch more of such videos.

    • @Csharp-video-tutorialsBlogspot
      @Csharp-video-tutorialsBlogspot  4 роки тому

      Hello Evangeline - Thank you very much for the feedback. Means a lot. I have included all the sql tutorial videos, slides and text articles in sequence on the following page. Hope you will find it handy.
      www.pragimtech.com/courses/sql-server-tutorial-for-beginners/
      When you have some time, can you please leave your rating and valuable feedback on the REVIEWS tab. It really helps us. Thank you. Good luck and all the very best with everything you are doing.

  • @TheSwatirock
    @TheSwatirock 6 років тому

    you explain each and every topic so easily....try to post more videos on sql server and oracle..good work and keep it up :)

  • @ranjitkj
    @ranjitkj 6 років тому

    Thank you very much for such a nice presentation. Awesome

  • @kunalchanda4854
    @kunalchanda4854 2 роки тому

    Really wonderful video and clear explanation. Thank you.

  • @41abhishek
    @41abhishek 7 років тому +39

    insert into mySelf values (select * from kudvenkat) .... Thanks a lot sir...

    • @MrShivam24
      @MrShivam24 6 років тому +3

      create table myself as (select * from kudvenkat)

    • @spacetime61
      @spacetime61 3 роки тому +2

      Insert into AbhishekSaha values (
      select GoodStuff
      from kudvenkat
      where GoodStuff = 'Penis'
      )

  • @tohidtaghizadeh728
    @tohidtaghizadeh728 7 років тому

    you have very usefull tutorials Thank You very much