How to Write Stored Procedure in SQL Server for Beginners
Вставка
- Опубліковано 20 гру 2016
- This Video explains how to write stored procedures in SQL Server 2008 and SQL Server 2014 using SQL Server Management Studio.
Excel sheet drive.google.com/file/d/1M_5J...
How to Write Queries in SQL Server and MS Access here: bit.ly/2IOx0Kz
SQL DBMS for Beginners(Practicals): bit.ly/2DBNJwm
SQL Database Management Systems for Beginners(Hands-On): bit.ly/2XSD205
How To Create a Database in MS SQL Management Studio: bit.ly/2VvI6Ki
For all tutorials visit: www.kindsonthegenius.com
Subscribe Kindson The Tech Pro UA-cam: bit.ly/2PpJd8Q
Join my group ICS on Facebook: bit.ly/2UULiQj
Follow me on Instagram - / kindsonm
Connect with me on LinkedIn: / kindson
Follow me on Twitter: / kindsonm
Learn about me: www.kindsonthegenius.com
More on: www.kttpro.com
kindsonmunonye.blogspot.com
kttpro.blogspot.com
How to Write Stored Procedure in SQL Server is Really very easy - Комедії
Thanks for this. Greetings from Nigeria. it is great seeing Nigerians push out great SQL content
this is simply great for a beginner! Thank you.
I was glad to see that your tutorial has an accompanied table i can work with.
Your simplicity of teaching was top notch too, kudos!!!
the way u teach is easy to understand...thank you...
Great video, not even my teachers explained it as you did, thank you!!!! Im off to do my homework now.
Perfect way to explain how it works!!! Awesome!!
Thank you Sir, I have learned a lot today by watching this short video. God Bless
thank you. now i wiill show others exactly this way
Excellent video. Straight and to the point.
Thanks for making such a somewhat complicated topic easy to understand, you just earned a subscriber.
Thanks for this wonderful piece, how do I get the excel data link?
Excellent video for those with basic MS SQL knowledge. Well done.
Thanks
Thank you, this helped me get the basics down.
This was helpful to refresh my memory after being out of work for months because of the U.S. government's failure to handle COVID. Thanks!
You just made it more easier than class. I just subscribed, thank you
You're welcome!
Simple and to the point. Thanks
Great job. I learned some good information! Thank you
This was very helpful! Thank you!
Awesome video. Short and to the point
Thank you very much for this video. I did not realize the simplicity of stored procedures. Great for beginners or individuals, such as myself, who need refreshers.
You're very welcome!
Mesej yang jelas, struktur yang jelas, mudah difahami, terima kasih
Good approach to follow -- thank you!!
You answered my question. Thank you! and have a like.
I was doing this for work for a month and was so confused.
This video just clears it up!
I know I'm quite randomly asking but does anyone know of a good place to watch newly released movies online?
@Markus Kelvin Flixportal
@Adam Onyx Thank you, signed up and it seems to work =) I appreciate it !!
@Markus Kelvin Glad I could help :D
This video was fantastic ! straight to the point.
Thanks a lot. Also do remember to subscribe to get updates. And feel free to mention any topic you would like to have a video on
your english accent is canadian's frensh accent..thank you ^-^
A very helpful video, straightforward
Thanks man, needed this!
Bro that really helped easy and simple
Really helpful man, thank you
Thank you so much , this video helped me a lot
Thank you, it's really helpful👌👍
Well prepared and informative. Simply explained. Thank you.
Glad it was helpful!
Clear Explanation! Thank you very much
Glad it was helpful!
Good keep it up youtube on first number video....
Thank you this is awesome
Hi guys, thanks for being there! You could support my channel by buying me a coffee buymeacoff.ee/PWsXo7h13
THANK YOU!
good video. Thank you
Thank you!!!!
Thank you sir
You need more views.
It Really helps me
Thanks. Do subscribe for more. You could also mention a topic you would like to get lessons on
Leaving the office I'll send my questions from home in about an hour. Thank you
Who do you think you are?
Thank you!
You're welcome!
helpful thanks
NICE PROCEDIO
helpful video
OMG thanks
Thaaaaaaaaank youuuuuuuuuuuuu! :D
You're so welcome!
Спасибо! понятно.
большое спасибо
"Whole lot of CRAP!" :D Thanks for the video. Still relevant in 2022!
thank you
Thanks too. Do remember to subscribe so you get updates
Great video
Thanks!
helpful video.
Glad it was helpful!
Can one create a stored procedure if one only has read permissions?
does create procedure is same way with create parameter?
01:56 This made me laugh. You could solve every bug by a simple delete.
I too laughed so hard on this.
I liked the way you said ...This is all crap ,,Just delete :) too good video very simple and very informative
How to write a stored procedures which finds duplicate procedure name and removes it if exist.
how do i access the excel data sheet
Need with more parameters
love u son
Hii, could I pls share the link to download excel.. That u hav used here
Sure.. see direct link drive.google.com/file/d/1M_5JRreYr3dkFo45juoVfjhv6fVMwkim/view?usp=sharing
Why did you hardcode the name in the stored procedure? in real life I would never hard code a name in a stored procedure that I wanted to change.
I think you are refering to the filter criteria (WHERE Firstname = 'KTTPRO').
This is different from the parameter @Firstname. It's just by chance that both are the same in this demo, but they are two different things.
Store procedure parameters should not be hardcoded, that is correct and I think that's what you mean. But filter criteria could be specified based on requirements and therefore could include literals.
Does this clearify it?
Hello, are you available for questions?
Sure... that is what I'm here for. Go ahead to ask.
@@KindsonTheTechPro Hello, I;m a new DBA and I have many simple questions connecting the dots. My SQL needs refreshing. I would like assessment of a project i just completed. Is this something you provide? Do you share your email?
@@dorothye2 Please send me a pm on LinkedIn or any other channel as I can't share my personal email in here the comments.
"In less then 5 minutes"... the video: 07:36
the sound is not good I am quite disappointed
I see that. I've replaced my mic and other gears.
So you can be sure that new videos on my channel are great now!
thank you
Thanks a lot. Remember to subscribe so you get notified when I make new lessons