Advantages of stored procedures Part 21

Sdílet
Vložit
  • čas přidán 23. 08. 2012
  • Benefits of using stored procedures over inline sql or adhoc sql
    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 CZcams 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
    czcams.com/users/kudvenka...
    All Dot Net and SQL Server Tutorials in Arabic
    / kudvenkatarabic

Komentáře • 73

  • @anthonyduque4320
    @anthonyduque4320 Před 3 lety +70

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

  • @krzysztofs8535
    @krzysztofs8535 Před 7 lety +8

    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 Před 11 lety +4

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

  • @jagdeepsingh5776
    @jagdeepsingh5776 Před 8 lety +1

    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

  • @psinghni
    @psinghni Před 11 lety +1

    Excellent tutorials! Thank you Venkat!

  • @hassanmansaray6980
    @hassanmansaray6980 Před 6 lety +2

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

  • @sumbalkhan9902
    @sumbalkhan9902 Před 5 lety

    Thank you so much! Great Tutorial !

  • @krismaly6300
    @krismaly6300 Před 9 lety +1

    Revisiting
    Thanks a bunch

  • @GeorgePatterson-bl4mv
    @GeorgePatterson-bl4mv Před 5 lety

    Thank you! Good info.

  • @anushan8036
    @anushan8036 Před 2 lety +5

    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 Před rokem

      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 Před 6 měsíci

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

  • @sindhujavijayakumar5747

    Really good clarity . God bless you

  • @rutvikpatel5127
    @rutvikpatel5127 Před 7 lety

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

  • @shanmukharao3378
    @shanmukharao3378 Před 11 lety +2

    Nice Explain to each and everything thank you.

  • @ezazhaider3466
    @ezazhaider3466 Před 6 lety

    Good explanation. Thanks for Sql videos

  • @sandeepbj2815
    @sandeepbj2815 Před 7 lety

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

  • @Csharp-video-tutorialsBlogspot

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

  • @rugwizainnocent1881
    @rugwizainnocent1881 Před 3 lety

    This man is simply the best

  • @sarithanalluri2850
    @sarithanalluri2850 Před rokem +1

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

    • @RahulKumar-lv9yz
      @RahulKumar-lv9yz Před rokem

      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 Před 6 měsíci

      @@RahulKumar-lv9yz yes its relatable

  • @chibumbamohammed5006
    @chibumbamohammed5006 Před 2 lety

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

  • @programmeseekho2795
    @programmeseekho2795 Před 6 lety

    Thank You Sir
    Very helpful Video..Very Nice Sir

  • @fratkalkan7850
    @fratkalkan7850 Před 6 lety

    Thank you so much Sir.

  • @cpujoltarres
    @cpujoltarres Před 11 lety

    Very well explained!!

  • @piyasidey2117
    @piyasidey2117 Před 8 lety

    Thank You Very much Sir...

  • @excelanalyticswithshailend5110

    Awesome :)

  • @dhanushs3675
    @dhanushs3675 Před 4 lety

    Best Explanation..

  • @ameya9909
    @ameya9909 Před 11 lety +1

    Excellent teaching style and material. Thank you!

  • @seniortaco100
    @seniortaco100 Před 11 lety

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

  • @germanhabreu
    @germanhabreu Před 8 lety +2

    Great Video.

    • @Csharp-video-tutorialsBlogspot
      @Csharp-video-tutorialsBlogspot  Před 8 lety +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
      czcams.com/users/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.
      czcams.com/video/y780MwhY70s/video.html
      If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel.
      czcams.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.
      Best Regards
      Venkat

  • @ferrarikarthik1
    @ferrarikarthik1 Před 11 lety

    Yet again Nice video...!

  • @garimasingh9248
    @garimasingh9248 Před 8 lety

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

  • @fysfakfysfak8990
    @fysfakfysfak8990 Před 3 lety

    Thank you 1000 000 times

  • @rupakshrestha9694
    @rupakshrestha9694 Před 5 lety

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

  • @zigtech5799
    @zigtech5799 Před 8 lety +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 Před 8 lety +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 Před 4 lety

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

  • @madhumitamajhi4965
    @madhumitamajhi4965 Před 4 lety

    Good explanation ☺️

  • @shatakhian
    @shatakhian Před 7 lety

    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 Před 3 lety

      Did you got placed?

    • @shatakhian
      @shatakhian Před 3 lety +1

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

    • @coderkamboj6104
      @coderkamboj6104 Před 3 lety

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

    • @shatakhian
      @shatakhian Před 3 lety +2

      @@coderkamboj6104Now MS SQL database developer.

    • @coderkamboj6104
      @coderkamboj6104 Před 3 lety

      @@shatakhian That's great bro.

  • @EL12111
    @EL12111 Před 4 lety +1

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

  • @simonm1229
    @simonm1229 Před 11 lety

    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

  • @Ty1er
    @Ty1er Před 2 lety

    thanks

  • @chaudhryalisalam3668
    @chaudhryalisalam3668 Před 9 lety +1

    could you please describe how we could filter dates in query

  • @shanthilakshmi2491
    @shanthilakshmi2491 Před 11 lety

    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

  • @santanupuhan1259
    @santanupuhan1259 Před 7 měsíci

    Wawoooo

  • @Bhaweshgupta
    @Bhaweshgupta Před 4 lety +1

    This guy is GOD

  • @lovelykaur2791
    @lovelykaur2791 Před 11 lety

    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???

  • @kirannadukula5247
    @kirannadukula5247 Před 11 lety

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

  • @pvb1905
    @pvb1905 Před 3 lety

    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 ?

  • @lovelykaur2791
    @lovelykaur2791 Před 11 lety

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

  • @prathameshsawant3081
    @prathameshsawant3081 Před 4 lety

    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 )

  • @SathishKumar-gs4er
    @SathishKumar-gs4er Před 7 lety

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

  • @niky1986813
    @niky1986813 Před 11 lety

    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

  • @ManinderSingh-vi4tz
    @ManinderSingh-vi4tz Před 2 lety

    Favourite question in TCS interview🤫

  • @stutitehri993
    @stutitehri993 Před 10 lety

    sps are very important

  • @saisivakiran4245
    @saisivakiran4245 Před 4 lety

    Are they have same concept as PL-SQL ?

  • @bornofdata
    @bornofdata Před 3 lety

    can you post the link to sql injections here?

  • @jasonleelawlight
    @jasonleelawlight Před 11 lety +1

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

  • @chibumbamohammed5006
    @chibumbamohammed5006 Před 2 lety

    Cn i take sql server course from your platform

  • @piyasidey2117
    @piyasidey2117 Před 8 lety

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

  • @Shankar-zi3yk
    @Shankar-zi3yk Před 5 měsíci

    can u explain in a more real time sir

  • @pksaravanan
    @pksaravanan Před rokem

    Uotoou