HomeОбразованиеRelated VideosMore From: kudvenkat

Stored procedure output parameters or return values Part 20

696 ratings | 266775 views
In this video we will 1. Understand what are stored procedure return values 2. Difference between stored procedure return values and output parameters 3. When to use output parameters over return values Text version of the video http://csharp-video-tutorials.blogspot.com/2012/08/stored-procedure-output-parameters-or.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-20-stored-procedure-output.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Html code for embedding videos on your blog
Text Comments (70)
Raihan Taher (1 year ago)
Excellent! Thanks for all your videos. You are amazing. Keep up the good work.
Raihan Taher (1 year ago)
Thanks Venkat. I will share with my friends. :-)
kudvenkat (1 year ago)
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 https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd If you need DVDs or to download all the videos for offline viewing please visit http://www.pragimtech.com/order.aspx Slides and Text Version of the videos can be found on my blog http://csharp-video-tutorials.blogspot.com Tips to effectively use my youtube channel. https://www.youtube.com/watch?v=y780MwhY70s If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel. http://www.youtube.com/subscription_center?add_user=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. Good Luck Venkat
xuan duan (2 months ago)
where can i download that sample database? i wanna use it as practice..
pramod maurya (2 months ago)
Thanks.. thanks.. thanks
chandu kumar (3 months ago)
create proc my as begin return 1; end declare @id int ; exec @id =my select @id
R P (4 months ago)
one thing i don't get is when executing Stored Procedure, why he had @total, after execute spGetTotalCount1. Where and why @total was added after spGetTotalCount1
Malak We Shaytan (4 months ago)
how return more than value with output parameters
Keyur Shah (5 months ago)
i want to delete data from coloum which is present in 2 table in 1st table it is primary key and in second table it is foregin key..so when i delete data from 1st table that it autometicaly delete from the second table by refering frome first one
kudvenkat (5 months ago)
This should be very easy to implement. Cascading referential integrity constraint helps you do this. To understand what this means, please check out the following video. Hope this helps. https://www.youtube.com/watch?v=ETepOVi7Xk8
Yusuf Mohamed Salh (6 months ago)
Create Procedure spGetNameById2 @name nvarchar(20) as Begin Return (Select Name from tblEmployee Where Id = @Id) End--this code will work ,so I can return a non integer value in the return value ,why you said it gives error ?
Josh Fraser (6 months ago)
I love your videos. And unlike other people you have a large inventory!
Andrei Gabriel Dragan (9 months ago)
1:00 "If you open the Programmability folder you should see SP dbo.spGetNameById...we have created this SP in the previous session"...No "we have not".
Miguel Vasquez (8 months ago)
I was thinking the same thing and went back a video just in case i missed something. I tried to create my own but did not have the same results
trishkiah trmtcha (11 months ago)
YOU ARE MY FAVE EVER!!!!!!!!!!!!!!!
pancha Subba (1 year ago)
Why u gotta put (+) sign before @name Somebody explain plz
Boss 7k (1 month ago)
bec when you have to concatenate you have to add a + sign i think so
Jhonatan Siles (1 year ago)
Thanks a lot !
Zamin Hassnain (1 year ago)
Awesome video.. have you also made video related to normalization ?
Mamun Khan (1 year ago)
Hi I am very much benefited from your video on SQL. How can I learn SSIS, SSAS, SSRS? Also How can I get those installed to SQL Server Management Studio 2017. Your guidance will be highly appreciated.
Mandeep Singh (1 year ago)
Hello @Kudvenkat - Can we get multiple rows using outpur parameter in Stored proc?? Plz answer
Dheeraj Siddheshwar (1 year ago)
hi sir, just one small clarification, can a stored procedure have more than one output parameters??? For example I need to build a stored procedure that returns the age and city of a particular employee. Can I do that with single SP or should I write two SPs for that?
Nikhila nikki (11 months ago)
yes it can have more than one output parameters
Univ Univeral (1 year ago)
Please can someone tell me the difference between PRINT and SELECT?
Nikhila nikki (11 months ago)
as far as I know.. print is printing values on console level of SQL.. (Under messages tab) Select gives output on Tabular format.. (Under Results tab)
Armando Capistran (1 year ago)
Thank you for playing...
Vishwanathen Panicker (2 years ago)
thanks
Piyasi Dey (2 years ago)
You are the best....Thank You very much Sir ...
Justin Li (2 years ago)
this man is a legend!
Eww Eww (2 years ago)
return does not design to get value, just use output for that purpose.
Amiable Youtuber (2 years ago)
Venkat, Stored procedure can return text values as well , if you declare the return type
Salman Shaikh (2 years ago)
I wish you made Oracle SQL videos also!!!
Parikshith Gari (3 years ago)
Hello Venkat, In the beginning of this video you told that 'Zero' indicate Success and 'non Zero' indicates failure but the example you showed a success with a return value of '10'. Can you please throw some light on it. Thanks, Parikshith
ziiip (1 year ago)
That's the default behaviour, but you can overwrite it to return something else. In this case it returned the number of employees in the table.
Murthy (Aditya) (1 year ago)
Hi I got the same doubt. Any update on this? please respond.
Ji Jianpeng (2 years ago)
+Parikshith Gari Have you got your answer? Same question here
Pixelated Network (3 years ago)
For the first time he said, "Can we do that? No, we can not.". He usually says "Absolutely" :)
Tanim Uddin (1 year ago)
haha
Bledar Kulemani (3 years ago)
lol
Mohit Singla (3 years ago)
Really Amazing videos Sir!!
Martin Pellicore (3 years ago)
I have no idea what has motivated you to create all of these videos. But thank you. You're the shit. These videos are amazing
Patrick Gomes (10 days ago)
Your peculiarly American compliment probably has Mr Venkat scratching his head. :-)
Hesham Amer (3 years ago)
thanks much Kudvenkat very good videos
Lavanya Arumugam (3 years ago)
Hi, your really doing a very good job..thank you so much for all your videos...keep doing this good...can you show us videos on open row set concepts in sql server 2008
Hi Kudvenkat, Excellent videos with good explanations for all SQL Server topics. Thanks for helping us with these awesome tutorials.
Ahmed Raees (4 years ago)
Hi Venkat, You are really doing a great job...Please keep it up...Thanks for helping us with these awesome tutorials.
#Stuti# #Tehri# (4 years ago)
output paramters are very important than return values
Magdarl John-Efe (4 years ago)
Thanks Tuomo. I appreciate your response.
Magdarl John-Efe (4 years ago)
Hi Kudvenkat, What is the point using an output parameter when I can just write the stored proc without it and get the same output? Kindly explain the need for an output parameter. Thanks.
Adofre (4 years ago)
Output parameters are not very useful when displaying info to a user. They will however be useful when you want to do further processing with the returned values. Maybe you are calling the procedure from another procedure that makes some calculations with the data.
joni22 (4 years ago)
thank you very much,,i have learn a lot from you 
Bhushan Harode (4 years ago)
Venky, you may go ahead and make a video on grass growing and I am sure we all would be interested in it. You are SIMPLY the BEST!
Bharani Chakravarthy (4 years ago)
Your Tutorials helped me a lot, I am learning C#.NET through your Tutorials and completed my project. Mainly your Grid View Tutorials are incomparable. Thank you for sparing time for us creating tutorials. "You are Master" - Small Size Institute on Youtube.
Adrien Tancrez (4 years ago)
Best teacher in the world
Ashif Shaikh (5 years ago)
Thank you very Much Kudvenkat your videos are truly very helpful. at  this time when everyone is barking for money, you are giving us free quality training. thanks
Surampudi Tpdevi (5 years ago)
hi hari thae power point presentaion is in his blog you can check it once
kudvenkat (5 years ago)
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.
Nikhila nikki (11 months ago)
Thanks for your hardwork.. Really Awesome videos.
Khaled Farawila (5 years ago)
I mean it sir , you are a master .
Indra Poudel (5 years ago)
I learned so much, Thank you Venkat, you are really a good teacher
Harish Reddy (5 years ago)
Superb Presentation in a very concise way but still managing to covering all important topics.I can say Venkat is the best teacher i have ever seen.So Folks subscribe for his channel which has covered a lot of other topics too.
Jay Maharaj (5 years ago)
Thank you
Aniruddha Singh Tomar (5 years ago)
Thanks Sir
JoseDraga (5 years ago)
Excellent explanations, this is just what I was looking for. Thanks a lot! Greetings from Argentina
Shashidhar Suroju (5 years ago)
awesome tutorial .superb presentation .
Sandeep Thandu (5 years ago)
Thanks for all videos
Drumans (5 years ago)
good videos. u have all the required content organised. gonna be useful
Mourad Barakat (6 years ago)
GREAT WORK!
Kiran Pedamkar (6 years ago)
sir one more request i want to do is that in the .NET basics tutorial you have been said that some remaining thing like (satelite assemblies and other several benefits of .net application) will talk in grate details in later session but there is no video tutorial on these i found, please upload that also... sir you are doing great job, your explanation one each content help us to understand easy to fresher like me, sir don't stop doing this....
Kiran Pedamkar (6 years ago)
that is superb video it will help me lot, don't stop doing this keep it up and one more thing pls upload videos on ADO and ASP .NET... tremendous job

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.