Stored Procedure VS Simple SQL | SQL Tutorial | Learn SQL Step by Step

Поділитися
Вставка
  • Опубліковано 11 гру 2024
  • Buy SQL Server course from here www.questpond....
    For more such videos visit www.questpond.com
    For more such videos subscribe www.youtube.co...
    See our other Step by Step video series below :-
    For more such videos subscribe / questpondvideos
    JavaScript Interview Questions: • JavaScript Interview Q...
    Learn SQL Server Step by Step tinyurl.com/ja4...
    Learn MSBI Step by Step in 32 hours:- goo.gl/TTpFZN
    Python Tutorial for Beginners:- • Python Tutorial for Be...
    Learn Data Science in 1 hour :- tinyurl.com/y5...
    Learn Power BI Step by Step:- tinyurl.com/y6...
    PHP Interview Questions : • PHP Interview Question...
    C# tutorial for beginners(4 hrs):- • C# Tutorial for Beginn...
    Learn Azure Step by Step:- • Azure Tutorial for Beg...
    Azure AZ-900 fundamentals certification :- • AZ 900 Certification |...
    Angular Interview Questions and Answers :- • Angular Interview Ques...
    Learn Angular tutorial step by step tinyurl.com/yc...
    Learn MVC 5 step by step in 16 hours:- • Learn ASP.NET MVC 5 ( ...
    Learn Design Pattern Step by Step goo.gl/eJdn0m
    Learn Tableau step by step :- tinyurl.com/kh...
    Preparing for C# / .NET interviews start here • C# Interview Questions...
    Video :- Stored procedure VS Simple SQL performance comparison
    -----------------------------------------------------------------------------------------------
    For more details :-
    🌐 Website : www.questpond.com
    📱 Mob. No. : +91-9967590707 / +91 7700975156 / +91-22-49786776
    📧Email : questpond@questpond.com / questpond@gmail.com / questpond@yahoo.com
    Share, Support, Subscribe and Connect us on!!!
    UA-cam: / questpondvideos
    Twitter: / questpond
    Instagram : / questpond
    Facebook : / questpond
    #SQLTutorial #StoredProcedurevsSimpleSQL #SQLTutorial #DifferenceBetweenStoredProcedure&Simple #SQLStepbyStep

КОМЕНТАРІ • 22

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

    20+ SQL Server Interview Questions : ua-cam.com/video/SEdAF8mSKS4/v-deo.html
    20 MSBI Interview Questions : ua-cam.com/video/Nw_sHEKnOUE/v-deo.html
    10+ Power BI Interview Questions : ua-cam.com/video/Cozc9WNBRt4/v-deo.html
    SQL Server Joins : ua-cam.com/video/KTvYHEntvn8/v-deo.html
    SQL Step by Step - ua-cam.com/video/uGlfP9o7kmY/v-deo.html
    Software Architecture Interview Questions : ua-cam.com/video/AtTgcbLOqMM/v-deo.html
    Angular Step by Step Tutorial for Beginners : ua-cam.com/video/-9VcW7MBDs8/v-deo.html
    25 Angular Interview Questions : ua-cam.com/video/-jeoyDJDsSM/v-deo.html
    35 Important JavaScript Interview Questions : ua-cam.com/video/Zb4dPi7CANU/v-deo.html
    30 Important C# Interview Questions : ua-cam.com/video/BKynEBPqiIM/v-deo.html
    25+ OOPS Interview Questions : ua-cam.com/video/u99wAoBjDvQ/v-deo.html
    25 Important ASP.NET Interview Questions : ua-cam.com/video/pXmMdmJUC0g/v-deo.html
    20 PHP Interview Questions : ua-cam.com/video/1bpNSynUrl8/v-deo.html
    5 MSBI Interview Questions : ua-cam.com/video/5E815aXAwYQ/v-deo.html
    20 MySQL Interview Questions : ua-cam.com/video/9hfjC-BpY20/v-deo.html

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

    Mesej yang jelas, struktur yang jelas, mudah difahami, terima kasih

  • @michelleport1
    @michelleport1 7 років тому +5

    You are excellent , not only you tell the make a topic understand ,but also clear basics and other concept related to that topic

  • @sankalpkumar2461
    @sankalpkumar2461 5 років тому +1

    Thank you so much...this video is clear my doubt about query execution plan.

  • @edwardhutagalung7021
    @edwardhutagalung7021 4 роки тому +1

    good and clear explanation with nice examples. thks a lot

  • @sebamary9634
    @sebamary9634 4 роки тому +1

    It was really helpful.

  • @questpondvideos
    @questpondvideos  12 років тому +2

    Stored procedure VS Simple SQL performance comparison

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

    why is it that it only hits when I don't change the first parameter? if I change the first parameter it inserts

  • @suryakanthbhullha7425
    @suryakanthbhullha7425 4 роки тому +1

    Please keep it up..

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

    Thank you, it was helpful.

  • @itranjan
    @itranjan 5 років тому +1

    Excellent.

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

    Sorry but what you're actually comparing in this video is performance of a parameterized query vs a non-parameterized (dynamic) query. You should have instead compared a stored procedure vs a parameterized query. You'd then would see that plan is cached and re-used in both these cases, essentially eliminating your entire argument.

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

      Exactly. This is what i was thinking about.

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

      Can you give me reference for the comparison of stored procedure vs parameterized query?

  • @Ramesh_Kumar_
    @Ramesh_Kumar_ 5 років тому +1

    thank you, sir, it's very useful for my interview its a great explanation Sir, I can understand clearly

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

    Thank u a lot 👄

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

    wonderful

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

    I just release an all stored procedure data tier creator called DataTier.Net on GitHub: github.com/DataJuggler/SharedRepo
    DataTier.Net creates all the stored procedures and data tier for you. A stored procedure alternative to EF:
    ua-cam.com/video/hnkroLjgKfk/v-deo.html