Stored procedures in sql server Part 18

Поделиться
HTML-код
  • Опубликовано: 9 июл 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 RUclips 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
    ruclips.net/user/kudvenka...
    All Dot Net and SQL Server Tutorials in Arabic
    / kudvenkatarabic

Комментарии • 466

  • @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
      ruclips.net/user/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.
      ruclips.net/video/y780MwhY70s/видео.html
      If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel.
      ruclips.net/user/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 лет назад +30

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

  • @T2Mful
    @T2Mful Год назад +13

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

  • @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

    • @abhishekbadge5359
      @abhishekbadge5359 2 года назад +2

      Hi I have tried different SQL sources but yours is the best

    • @MyFlabbergast
      @MyFlabbergast Год назад +2

      Kindly pin this comment!

  • @natavesta2010
    @natavesta2010 6 лет назад +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.

  • @user-vm6fn2kg8z
    @user-vm6fn2kg8z 7 лет назад +63

    this man is a LEGEND!!

  • @LakmalHckz
    @LakmalHckz 6 лет назад +14

    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!

  • @azambuverra4209
    @azambuverra4209 Месяц назад +1

    How i wish i could meet you someday; just to say thank you to your face! You are my SQL Server teacher. 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.

  • @miguelmont4576
    @miguelmont4576 5 лет назад +9

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

  • @robbinsethi7476
    @robbinsethi7476 Год назад +1

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

  • @krzysztofs8535
    @krzysztofs8535 7 лет назад +2

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

  • @hollygrigsby3038
    @hollygrigsby3038 4 месяца назад

    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!

  • @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

  • @krishjotsarai425
    @krishjotsarai425 9 месяцев назад +1

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

  •  11 лет назад +1

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

  • @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 ) .

  • @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

  • @leonvieira3877
    @leonvieira3877 3 года назад

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

  • @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🤝

  • @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 🙏

  • @supa.scoopa
    @supa.scoopa 6 месяцев назад

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

  • @chrispang4035
    @chrispang4035 5 лет назад

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

  • @HAMZA-he9nd
    @HAMZA-he9nd 9 лет назад

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

  • @erassy5278
    @erassy5278 6 лет назад +1

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

  • @Patienze
    @Patienze Год назад +1

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

  • @raghavprasad277
    @raghavprasad277 3 года назад

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

  • @abhishekbadge5359
    @abhishekbadge5359 2 года назад

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

  • @OK-dy8tr
    @OK-dy8tr 2 года назад

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

  • @shwetaaswal3383
    @shwetaaswal3383 Год назад +1

    amazing!! Love the way you teach these topics.

  • @mukteshagamer5163
    @mukteshagamer5163 11 лет назад

    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 .. :)

  • @babzo1
    @babzo1 10 лет назад +1

    Always refreshing..
    Thanks Venkat

  • @wishingW3L
    @wishingW3L 10 лет назад

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

  • @piyasidey2117
    @piyasidey2117 7 лет назад +2

    Have no words to thank You Sir...

  • @Csharp-video-tutorialsBlogspot
    @Csharp-video-tutorialsBlogspot  11 лет назад +1

    Hi Shafiul, thank you very much for taking time to give feedback. I upload training videos on a daily basis. If you want receive email alerts when new videos are uploaded, please feel free to subscribe to my youtube channel.

  • @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.

  • @ismokepot123
    @ismokepot123 6 лет назад

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

  • @raghuanamala1125
    @raghuanamala1125 2 года назад

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

  • @gss1972
    @gss1972 11 лет назад +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

  • @thelonewolf9866
    @thelonewolf9866 3 года назад +1

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

  • @AMANSINGH-yv4vv
    @AMANSINGH-yv4vv 2 года назад

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

  • @YT_Master3488
    @YT_Master3488 2 года назад

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

  • @KedWebDev2011
    @KedWebDev2011 10 лет назад

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

  • @YaseenKhan-xm9dx
    @YaseenKhan-xm9dx 7 лет назад +3

    Best video on stored procedures. EXCELLENT!!!

  • @neerajadondapati4355
    @neerajadondapati4355 10 лет назад

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

  • @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.

  • @sunithareddyd22
    @sunithareddyd22 7 лет назад

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

  • @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.

  • @SatishDangol
    @SatishDangol 6 лет назад

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

  • @rohitsupa
    @rohitsupa 8 лет назад +8

    some of the best tutorial on STORED PROC

  • @ashwinishastrakar8795
    @ashwinishastrakar8795 3 года назад

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

  • @golammuhaimeen2825
    @golammuhaimeen2825 2 года назад +1

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

  • @edwardjacob4098
    @edwardjacob4098 3 года назад

    You are the best, Venkat.

  • @Learngroweducate
    @Learngroweducate 4 года назад

    Superb tutorials Nicely explained. Really appreciate. Thank you!

  • @Csharp-video-tutorialsBlogspot
    @Csharp-video-tutorialsBlogspot  11 лет назад

    Hi Thank you very much for taking time to give feedback. I am really glad you found these ideos useful. I want these tutorials to be helpful for as many people as possible. Please free to share the link with your friends and family who would also benefit from them. If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel. Good Luck.

  • @Cinematic-Frenzy
    @Cinematic-Frenzy 2 года назад

    9yrs down the line and you still the best

  • @7huannp
    @7huannp 6 лет назад

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

  • @kirtim1930
    @kirtim1930 3 года назад

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

  • @meghasyam427
    @meghasyam427 6 лет назад

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

  • @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👍👍❤️

  • @hanumankorlepara2207
    @hanumankorlepara2207 10 лет назад

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

  • @germanhabreu
    @germanhabreu 8 лет назад +4

    hands down the best explanation on Stored Procedures
    Thanks

  • @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.

  • @factworld4375
    @factworld4375 5 лет назад

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

  • @SonuKumarTech
    @SonuKumarTech 4 месяца назад

    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 RUclips 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.

  • @Jazz9699
    @Jazz9699 8 лет назад

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

  • @Ayubajbnabi
    @Ayubajbnabi 10 лет назад

    Excellent as usual. Thanks for the great work

  • @harikrishnasai6104
    @harikrishnasai6104 2 года назад

    Ur the epitome to teach sql ,TnQ so much sir

  • @andyyork6471
    @andyyork6471 8 лет назад +3

    Great Video!! I really appreciate the time and effort put into creating this. Thanks!

  • @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.

  • @rajkumarpalle8217
    @rajkumarpalle8217 Год назад

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

  • @mh_12rider44
    @mh_12rider44 4 года назад

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

  • @nikhilmdkr
    @nikhilmdkr 2 года назад

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

  • @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

  • @jkvelasquez84
    @jkvelasquez84 7 лет назад +3

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

  • @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 .

  • @debbyskitchen_by_funmi
    @debbyskitchen_by_funmi 3 года назад

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

  • @ikennaezeogu1200
    @ikennaezeogu1200 2 года назад

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

  • @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'
      )

  • @sofiaodborn2552
    @sofiaodborn2552 4 года назад

    Great video! Helped a lot!!

  • @bizzar31
    @bizzar31 11 лет назад

    you are not human sir ^^ , thank you for everything ,I'm gonna watch all your tuto , you are really a great tutor ,

  • @martinaullah1917
    @martinaullah1917 7 лет назад

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

  • @himanshurathi226
    @himanshurathi226 8 лет назад

    Thanx bro..........
    you gave me a good explanation and saved my time too......

  • @faizyrizvi4264
    @faizyrizvi4264 8 лет назад +1

    Great Job Kudvenkat ,really great explanation

  • @msajidh1970
    @msajidh1970 10 лет назад

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

  • @amkytube5242
    @amkytube5242 4 года назад

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

  • @benakin9172
    @benakin9172 10 лет назад +1

    cramming for an interview....this is a God sent

  • @thaboamos5106
    @thaboamos5106 5 лет назад

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

  • @osamashabbir3612
    @osamashabbir3612 4 года назад

    You sir, are a good teacher.
    Thank you.

  • @luccawu1016
    @luccawu1016 8 лет назад +5

    OMG! Best ever lecture regarding this topic

  • @douniachaouki7327
    @douniachaouki7327 8 лет назад

    That was very helpful ..u are amazing thank u

  • @TrangNguyen-vc5bt
    @TrangNguyen-vc5bt 2 года назад

    You are the best teacher!

  • @ranjitkj
    @ranjitkj 6 лет назад

    Thank you very much for such a nice presentation. Awesome

  • @momeveryday5466
    @momeveryday5466 Год назад

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

  • @gotchihaeyo1825
    @gotchihaeyo1825 Год назад

    Oh I love it love it!!!💗

  • @mrsinisa11aaa
    @mrsinisa11aaa 5 лет назад

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

  • @hessamharandi7954
    @hessamharandi7954 7 лет назад

    This is awesome, thank you Sir :)