Stored procedures with output parameters Part 19

In this video we will learn
1. Creating and executing stored procedures with output parameters
2. Learn about some of the useful system stored procedures

Text version of the video

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 YouTube channel. Hope you can help.

Slides

All SQL Server Text Articles

All SQL Server Slides

All Dot Net and SQL Server Tutorials in English

All Dot Net and SQL Server Tutorials in Arabic

[kevintech]

Dear Venkat; Please dont waste your life working in an IT thus incresing their profit;;not sure you are working in an IT firm
Recommand you to start life in teaching field in bigger universities, corporate trainig and poor pepople

as an it profession for 10 yrs, attended so many sessions, either this is one of the best session i ever encounder in my profession;the complex concept are simplified and the order in which you introduce the next concept is mind blowing...a smooth flow from one chapter to another...God Blass Venkat
Keep Moving forward...The tec generation wants you...moreever the common people wants You...

[Csharp-video-tutorialsBlogspot]

The quality of the video depends on your internet connection bandwidth. All the videos are uploaded in HD quality. To improve the video quality, click the settings button that is present at the lower bottom right hand corner of the youtube player. Hope this helps.

[Csharp-video-tutorialsBlogspot]

Since the variable is specified with output keyword, sql server knows to move the value from @EmployeeCount output parameter to the output variable. I hope this answers your question. To receive email alerts, when new videos are uploaded, please subscribe to my youtube channel. Please feel free to share the link with your friends and family who you think would also benefit from them. If you like these videos, please click on the THUMBS UP button below the video.

[krzysztofs]

You are master of SQL Server ! Thank you for your videos! Great job!

[srinivasprasad]

After seeing this video in my whole 2years experience I never come across this contents in my works...now it showing how useful seeing ur video.

[kartikeyverma]

I have just reached this 19th video and i must say this that i never had such a good youtube/video session on any thing/content before. I'm on my process to watch every video on it as I can see through all the 149 video titles that it covers Thanks a ton for these videos... Its helping a lot. I will comment on the last video also once I reach it :)

[NazaninYari]

your videos are just SO GREAT. I feel like it's not fair to watch all for free, is there anywhere to donate?

[Gigantum]

A bundle of thanks. Very good lectures and easy and simplistic way of disseminating knowledge.

[MrSam]

This is simply great Mr Venkat. Your explanations are perfect!

[raghum]

I have gone through all of your videos and it helped me so much in my professional carrier, thank you so much Venkat for your videos.

[AhmedHassan-wtss]

most professional lectures from this channel on youtube

[sanketkondvilkar]

Thanks a lot Venkat for explaining SQL concepts in easy to understand videos!

[junaidmalik]

Your Videos are helping me even after almost 10 years :). Thanks is a small word for the hard work have put behind making this content but still Thanks :)

[Eaglessoft]

Thank you very much making for these videos and putting all the time to create them and also put the in order for us. you helped me lot to under stand the tsql. your videos are the best so far i seen. even better then paid

[maheshs]

hats off to you Venkat, really lovely explanation. thanks a lot for your wonderful videos,

[sinoptik]

Dear Venkat!Thanks a lot for the great job you did! You channel is the best and ypur explanations are very detailed and useful! Thank a lot. Really!

[VaGande]

I really appreciate your way of explaining the db concepts or any technical concept is so good, clear and to the point. Which makes us to grasp and digest in no time.

Once again thanks Venkat for putting this effort in place for us.

[discoverthedebate]

i never learned about stored procedure in my university life.know i understood it very well you are great venkat thankyou very much

[bshaider]

well thanks allot venkat you are the best tutor i ever found on you tube

[Csharp-video-tutorialsBlogspot]

@EmployeeCount is an output parameter and is initialized by the stored procedure using the line below.
Select @EmployeeCount = Count(Id) from tblEmployee where Gender = @Gender

Execute spGetEmployeeCountByGender @EmployeeCount = @TotalCount out, @Gender = 'Male'