Stored procedures in sql server Part 18

Подписаться 827 тыс.

Просмотров 1,5 млн

50% 1

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 RU-vid 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
ru-vid.com...
All Dot Net and SQL Server Tutorials in Arabic
/ kudvenkatarabic

Опубликовано:

22 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 465

@gauravtaori498 7 лет назад

excellent. you are just fab

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

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 ru-vid.complaylists?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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-y780MwhY70s.html If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel. ru-vid.com 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 6 лет назад

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

@natavesta2010 6 лет назад

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!

@T2Mful Год назад

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

@azambuverra4209 Месяц назад

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

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 2 года назад

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

@MyFlabbergast Год назад

Kindly pin this comment!

@Trzbne 6 лет назад

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.

@LakmalHckz 6 лет назад

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!

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

this man is a LEGEND!!

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

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.

@miguelmont4576 5 лет назад

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

@socerboy06 9 лет назад

Best SQL Sever tutorial I've seen.

@krismaly 9 лет назад

You are right. Spread the word to your friends

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

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.

@rachhpalkaur2512 3 года назад

Thank you so much. your teaching skills are superb. I have not technical background but i learnt a lot from these videos. Best tutorials

@krzysztofs8535 7 лет назад

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

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

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

@robbinsethi7476 Год назад

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

@abrahammahmoudi7470 2 года назад

Like all other parts, you perfectly explain the things, I love your way of training!

@nazakatali3778 Год назад

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🤝

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

11 лет назад

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

@hollygrigsby3038 3 месяца назад

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!

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

@shwetaaswal3383 11 месяцев назад

amazing!! Love the way you teach these topics.

@anuragvashishtha6660 11 лет назад

Great content. Great presentation. Its a treat to learn SQL through your videos.

@naregtokatlian3663 5 лет назад

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

@babzo1 10 лет назад

Always refreshing.. Thanks Venkat

@HAMZA-he9nd 8 лет назад

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

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

@golammuhaimeen2825 2 года назад

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

@chrispang4035 5 лет назад

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

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

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

@jeroengrrb.4360 7 лет назад

This is much easier to understand than the microsoft book on quering ms sql....Thanks a lot!

@SantoshKumar.budithi 7 лет назад

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.

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

@SonuKumarTech 3 месяца назад

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

@azambuverra4209 Месяц назад

He is undoutedly awesome.

@Patienze Год назад

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

@piyasidey2117 7 лет назад

Have no words to thank You Sir...

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

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

@gss1972 11 лет назад

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

@sunithareddyd22 7 лет назад

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

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

@erassy5278 6 лет назад

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

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

Best video on stored procedures. EXCELLENT!!!

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

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

@rajkumarpalle8217 Год назад

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

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

@neerajadondapati4355 10 лет назад

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

@rohitsupa 8 лет назад

some of the best tutorial on STORED PROC

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

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

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

Superb tutorials Nicely explained. Really appreciate. Thank you!

@SatishDangol 6 лет назад

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

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

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

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

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

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

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

@KedWebDev2011 10 лет назад

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

@41abhishek 7 лет назад

insert into mySelf values (select * from kudvenkat) .... Thanks a lot sir...

@MrShivam24 6 лет назад

create table myself as (select * from kudvenkat)

@spacetime61 3 года назад

Insert into AbhishekSaha values ( select GoodStuff from kudvenkat where GoodStuff = 'Penis' )

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

@Ayubajbnabi 10 лет назад

Excellent as usual. Thanks for the great work

@ismokepot123 6 лет назад

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

@wishingW3L 10 лет назад

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

@germanhabreu 8 лет назад

hands down the best explanation on Stored Procedures Thanks

@thelonewolf9866 3 года назад

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

@Jazz9699 8 лет назад

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

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

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

@bizzar31 11 лет назад

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

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

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

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

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

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

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

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

@mounikapandra3879 3 года назад

your teaching is another level...........keep rocking

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

@meghasyam427 6 лет назад

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

@factworld4375 5 лет назад

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

@msajidh1970 10 лет назад

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

@faizyrizvi4264 8 лет назад

Great Job Kudvenkat ,really great explanation

@martinaullah1917 7 лет назад

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

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

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

@douniachaouki7327 8 лет назад

That was very helpful ..u are amazing thank u

@luccawu1016 8 лет назад

OMG! Best ever lecture regarding this topic

@himanshurathi226 7 лет назад

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

@hanumankorlepara2207 10 лет назад

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

@jkvelasquez84 7 лет назад

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

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

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

@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

@amin3663 11 лет назад

@ Venkat: This is amazing. I was exactly looking for this kind of robust explanation. Thank you so much man. I am sure not only me but also other viewers of your videos appreciate your work immensely. Once again thank you very much