Advantages of stored procedures Part 21

Поделиться
HTML-код
  • Опубликовано: 6 сен 2024
  • Benefits of using stored procedures over inline sql or adhoc sql
    Text version of the video
    csharp-video-tu...
    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-tu...
    All SQL Server Text Articles
    csharp-video-tu...
    All SQL Server Slides
    csharp-video-tu...
    All Dot Net and SQL Server Tutorials in English
    www.youtube.co...
    All Dot Net and SQL Server Tutorials in Arabic
    / kudvenkatarabic

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

  • @anthonyduque4320
    @anthonyduque4320 3 года назад +73

    This specific SQL Tutorial got me a job! No kidding!

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

    I' m on part 21 of 136 . Beautiful. I'm going to see all your videos to be well prepared from SQL Server.

  • @anuragvashishtha6660
    @anuragvashishtha6660 11 лет назад +5

    These are all really Important concepts, so far limited only to a seasoned programmer. Thanks for sharing it with the wider audience.

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

    I was really addicted to your voice and presentation skills and very glad to have tutors like you

    • @RahulKumar-lv9yz
      @RahulKumar-lv9yz Год назад

      Are these videos relatable to software versions being used even now, as I can see from comments that the video is almost 9-10 years old.

    • @mahmoudbarham9493
      @mahmoudbarham9493 7 месяцев назад

      @@RahulKumar-lv9yz yes its relatable

  • @anushan8036
    @anushan8036 2 года назад +6

    Thank you very much Sir, your training makes me love SQL. I am currently training myself for the position of data analyst and your videos helps me a lot. Once again thank you😊

    • @RahulKumar-lv9yz
      @RahulKumar-lv9yz Год назад

      Are these videos relatable to software versions being used even now, as I can see from comments that the video is almost 9-10 years old.

    • @sahilchavan5173
      @sahilchavan5173 8 месяцев назад

      works very well even today, not much has changed@@RahulKumar-lv9yz

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

    Thank yu Sir, you have really changed sql programming skill.

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

    Hi, you can try something like this. Select * from TableName where ID IN (1,2,3,4,5). Hope this answers your question.

  • @jagdeepsingh5776
    @jagdeepsingh5776 8 лет назад +2

    Brother no doubt you are too good .I am getting good knowledge with this stuff.Its been a couple of days, i started to explore your videos.Good luck

  • @hassanmansaray6980
    @hassanmansaray6980 6 лет назад +3

    wow, well understood. I congratulate your effort towards this enviable part

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

    great videos, I am getting ready for my Microsoft exam 70-461, and these videos are really helpful.
    Thank you too much

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

      What is the procedure to get ready for the exam in Microsoft? I want to sit for C#.net exams.Want information about this. If you can please help..

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

      hello tresor omari watching your comment after 3 years. did you cleared your microsoft test?

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

    This man is simply the best

  • @EL12111
    @EL12111 4 года назад +1

    These videos are GEM. I just hope Author remake them with high quality mic.

  • @shanmukharao3378
    @shanmukharao3378 11 лет назад +2

    Nice Explain to each and everything thank you.

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

    Thank you kudvenkat. Your videos are very usefull. I wish I saw your videos early times, because I've failed many interviews. Thank you very much.

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

      Did you got placed?

    • @shatakhian
      @shatakhian 4 года назад +1

      @@coderkamboj6104 Yes. Now I working in Prague, Czech Republic.

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

      @@shatakhian That's Great Bro. Can I know in which field in software development are you working.

    • @shatakhian
      @shatakhian 4 года назад +2

      @@coderkamboj6104Now MS SQL database developer.

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

      @@shatakhian That's great bro.

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

    Excellent tutorials! Thank you Venkat!

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

    smoothly explaination Sir ... nice video.....you are great

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

    Really good clarity . God bless you

  • @Bhaweshgupta
    @Bhaweshgupta 4 года назад +1

    This guy is GOD

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

    Excellent teaching style and material. Thank you!

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

    Ultimate explanation.....Useful tutorial....

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

    Good explanation. Thanks for Sql videos

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

    Thank you so much! Great Tutorial !

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

    Thank you 1000 000 times

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

    Best Explanation..

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

    You have an option from Solution Explorer to "Publish"...(Create Copy) your database to Management Studio and then from there you can do the Back up same way you do any database back up

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

    i think it means that some data which are change as per market (i.e. selling rate) are effect to RDBMS whole data .. if we keep all data related to change in stored procedure it will safe and does not effect on accounting/auditing of past record. Am I right ?

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

    Great Video.

    • @Csharp-video-tutorialsBlogspot
      @Csharp-video-tutorialsBlogspot  8 лет назад +2

      +German Abreu Thank you for taking time to give us your feedback. This means a lot. I am very glad you found the videos useful.
      Free Dot Net & SQL Server video tutorials to help you become a web developer
      ruclips.net/user/kudvenkatplaylists?view=1&sort=dd
      DVDs with all the videos and slides for offline viewing
      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.
      Best Regards
      Venkat

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

    I have one question ...I am stuck at that question...
    plz help me to solve @kudvenkat.
    Q)write a procedure that updates , delete based on appropriate paramaters provided...
    (Use Adventure works database 2016 )

  • @krismaly6300
    @krismaly6300 9 лет назад +1

    Revisiting
    Thanks a bunch

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

    Good explanation ☺️

  • @santanupuhan1259
    @santanupuhan1259 8 месяцев назад

    Wawoooo

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

    Thank You Sir
    Very helpful Video..Very Nice Sir

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

    hi . your all videos are so great. please tell me the link of your statistics and execution plan

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

    Very well explained!!

  • @GeorgePatterson-bl4mv
    @GeorgePatterson-bl4mv 5 лет назад

    Thank you! Good info.

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

    Hi, venkat could you please make videos on AJAX Controls. I watched a lot of videos but could not understand any of them because they are not a match to the way you explain. So, please make some videos on Ajax controls venkat. I request please...................

  • @chaudhryalisalam3668
    @chaudhryalisalam3668 9 лет назад +1

    could you please describe how we could filter dates in query

  • @excelanalyticswithshailend5110
    @excelanalyticswithshailend5110 9 лет назад +1

    Awesome :)

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

    Yet again Nice video...!

  • @SathishKumar-gs4er
    @SathishKumar-gs4er 8 лет назад

    Dear Venkat,
    i want to use the stored procedures in trigger..how i can do that??
    If you have any video please suggest me..

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

    Hi, Nice Tutorials. Could you provide tutorials on Boyce-Codd normal form.

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

    Thank You Very much Sir...

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

    Good job on explaining SP.
    What's your favorite script and what does it do?

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

    thanks

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

    Thank you so much Sir.

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

    Hi Venkat, thanks for the videos, can you please tell me what is inline SQL and about
    injecting sql link is not working, can u explain that also.
    Thanks,
    shanthi

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

    Are they have same concept as PL-SQL ?

  • @ManinderSingh-vi4tz
    @ManinderSingh-vi4tz 2 года назад

    Favourite question in TCS interview🤫

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

    hii venkat...i have an question ..... if i create a database in visual studio .... is it posible to create bkup of dat database and restore dat database smwhere else........
    how???

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

    Cn i take sql server course from your platform

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

    I was about to watch the recommended video on SQL injection attack but it says that video is unavailable

    • @anshumanchaudhury3504
      @anshumanchaudhury3504 5 лет назад +1

      It is available here
      ruclips.net/video/uSw0IoSr3Hk/видео.html

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

    means is it posible to save dat database insome folder as we do in ssms.....???

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

    can you post the link to sql injections here?

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

    Nice work. I just have one question, in ur where clause, u use ID=1 and re-exec use ID=2. How should I do if I want ID run from 1 to an inter instead of entering it line by line? I am a beginner of SQL user, if u have any video suggestion, it's nice as well. Thx

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

    sps are very important

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

    In better security what r u pronounce..Final grail..Final Grain..what?

  • @Shankar-zi3yk
    @Shankar-zi3yk 6 месяцев назад

    can u explain in a more real time sir

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

    Uotoou