Stored procedure output parameters or return values Part 20

No video

Stored procedure output parameters or return values Part 20

Рет қаралды 521,630

kudvenkat

Күн бұрын

Пікірлер: 101

@RaihanTaher 7 жыл бұрын

Excellent! Thanks for all your videos. You are amazing. Keep up the good work.

@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 kzfaq.infoplaylists?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. kzfaq.info/get/bejne/r51oY7Cozb-bYKc.html If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel. kzfaq.info 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

@RaihanTaher 7 жыл бұрын

Thanks Venkat. I will share with my friends. :-)

@haregewoingebra1798 3 жыл бұрын

Thank you so much, Very useful!

@iamboozi 10 жыл бұрын

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!

@onlineaccount-wh2yx 9 ай бұрын

Lot of knowledge in your videos ,but not at all overwhelming . You put everything in a easy to understand way. I can't thank you enough . 👏Thank you so much

@VO1D33 9 жыл бұрын

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

@patrickgomes15 5 жыл бұрын

Your peculiarly American compliment probably has Mr Venkat scratching his head. :-)

@shivarjunroy1394 5 жыл бұрын

Why Shit? Shit is s bad word. Pellicore Ji ,please don't use Shit. Use Great.

@TheJq32 4 жыл бұрын

@@shivarjunroy1394 calling something "the shit" is a compliment meaning it is of the highest quality

@adrienhide 10 жыл бұрын

Best teacher in the world

@ThePixelizedNetwork 9 жыл бұрын

For the first time he said, "Can we do that? No, we can not.". He usually says "Absolutely" :)

@bledarkulemani3793 9 жыл бұрын

lol

@huddini91 7 жыл бұрын

haha

@Csharp-video-tutorialsBlogspot 11 жыл бұрын

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.

@nikhilal3563 6 жыл бұрын

Thanks for your hardwork.. Really Awesome videos.

@vxragun80 10 жыл бұрын

Hi Kudvenkat, Excellent videos with good explanations for all SQL Server topics. Thanks for helping us with these awesome tutorials.

@MonderMurshed Жыл бұрын

Idk how i can thank u man! very appreciate your hard working.

@user-wh2tm3tl2k Жыл бұрын

Best course I came across so far.

@ronenslonim9656 3 жыл бұрын

Excellent - the best tutorials on SQL that I have seen

@hasinmahjabeen7252 4 жыл бұрын

This one is very much resourceful, cleared the concept between them. Thank you.

@joshfraser3991 6 жыл бұрын

I love your videos. And unlike other people you have a large inventory!

@teenachacko7340 5 жыл бұрын

Thank you for all the videos Sir! Every video is simple and easily understandable.

@JoseDraga 11 жыл бұрын

Excellent explanations, this is just what I was looking for. Thanks a lot! Greetings from Argentina

@denitsageorgieva7209 Жыл бұрын

You explain really well! I love your course!!

@indrapoudel8842 11 жыл бұрын

I learned so much, Thank you Venkat, you are really a good teacher

@nimeshambalalpatel3032 3 жыл бұрын

Excellent video teaching sir!!! We pray for your good health !! My Pranams

@ahmedraees5352 10 жыл бұрын

Hi Venkat, You are really doing a great job...Please keep it up...Thanks for helping us with these awesome tutorials.

@kiranpedamkar 12 жыл бұрын

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

@justinli19901027 8 жыл бұрын

this man is a legend!

@immortal5430 11 жыл бұрын

I mean it sir , you are a master .

@kiranpedamkar 12 жыл бұрын

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

@magdarljohn-efe1850 10 жыл бұрын

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.

@tseyontadesse7983 4 жыл бұрын

you are just unbelievably amazing

@lavanyaarumugam4055 9 жыл бұрын

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

@RandomGameHall 11 жыл бұрын

good videos. u have all the required content organised. gonna be useful

@veronicaviera4510 6 жыл бұрын

YOU ARE MY FAVE EVER!!!!!!!!!!!!!!!

@piyasidey2117 8 жыл бұрын

You are the best....Thank You very much Sir ...

@SuperGojeto 8 жыл бұрын

I wish you made Oracle SQL videos also!!!

@shashidharsuroju3940 11 жыл бұрын

awesome tutorial .superb presentation .

@saharazeem5588 5 жыл бұрын

Venakt thank you so much you are great

@DevilSoul969 4 ай бұрын

Best vedio useful 👏

@mohit4230 9 жыл бұрын

Really Amazing videos Sir!!

@magdarljohn-efe1850 10 жыл бұрын

Thanks Tuomo. I appreciate your response.

@amiableyoutuber723 8 жыл бұрын

Venkat, Stored procedure can return text values as well , if you declare the return type

@sandythandu 11 жыл бұрын

Thanks for all videos

@shashidharc9122 5 жыл бұрын

Best till date

@mamun1456 7 жыл бұрын

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.

@mouradbarakat123 12 жыл бұрын

GREAT WORK!

@berzaipeter2736 3 жыл бұрын

In which video you created spGetNameById? Because I looked in the previous and the one before, and sadly didn't found that.

@bharatchauhan3242 3 жыл бұрын

I had a doubt that in starting of video you told that returning zero means success and returning non zero value means failure but when we actually return count of employees for example we are returning a non zero value but that is a successful run. So I am a bit confused here.

@zaminhassnain7570 7 жыл бұрын

Awesome video.. have you also made video related to normalization ?

@priyanksatasiya1366 4 жыл бұрын

just awesome....

@parikshithgari7501 8 жыл бұрын

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

@jijianpeng7368 8 жыл бұрын

+Parikshith Gari Have you got your answer? Same question here

@murthy241able 7 жыл бұрын

Hi I got the same doubt. Any update on this? please respond.

@ZiiiP2142 7 жыл бұрын

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.

@nys8260 3 жыл бұрын

usually not always

@mandeepsingh175 7 жыл бұрын

Hello @Kudvenkat - Can we get multiple rows using outpur parameter in Stored proc?? Plz answer

@jhonatansiles4455 7 жыл бұрын

Thanks a lot !

@94dheeraj 7 жыл бұрын

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?

@nikhilal3563 6 жыл бұрын

yes it can have more than one output parameters

@RamaKrishna-ll8iz 7 ай бұрын

Hi, Could you please help me to understand why output parameters needed when we can get same result using input parameters

@arthurpoghosyan7231 2 жыл бұрын

Great job. Does anyone has the dataset of this SQL series? Please it will help me a lot.

@TheJq32 4 жыл бұрын

why does the declared variable have a different name than the output parameter name in the procedure? In this example, why do we declare @Total? Why not just declare @TotalCount?

@gregorym7598 4 жыл бұрын

I just want from you to tell me where in the previous session we (actually you) created stored procedure spGetNameById... because I didn't do that...

@lipunpatel5937 Жыл бұрын

Can Output parameter be of Temp Table or Table Variable data type ?

@pramodmaurya6610 6 жыл бұрын

Thanks.. thanks.. thanks

@gkmishra2009 2 жыл бұрын

great

@RP-nf7fl 6 жыл бұрын

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

@shipperification 4 жыл бұрын

Can we return a table using stored proecdures?

@stutitehri993 10 жыл бұрын

output paramters are very important than return values

@TheManHimself06 6 жыл бұрын

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

@miguelvasquez5099 6 жыл бұрын

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

@mrsinisa11aaa 5 жыл бұрын

This procedure was not creates, but it is not important at all, you can use any other stored procedure. The Venkat's point was to describe difference between output parameter and return value

@sikandar361 5 жыл бұрын

Sir, I've used a similar syntax in SQL developer but it caused an error?

@yusufmohamedsalh8321 6 жыл бұрын

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 ?

@prajapati22 11 жыл бұрын

Thank you

@williamwei7899 4 жыл бұрын

After watching this, I can't help wondering why we need return value...

@Capistream8bits 7 жыл бұрын

Thank you for playing...

@ssbigdata6732 3 жыл бұрын

Thankyou

@keyurshah1366 6 жыл бұрын

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

@Csharp-video-tutorialsBlogspot 6 жыл бұрын

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. kzfaq.info/get/bejne/e7qVo7KHzp28m2w.html

@JonathanIsmaila 4 жыл бұрын

Please how do I get the output value in my visual studio project?

@devi07461 11 жыл бұрын

hi hari thae power point presentaion is in his blog you can check it once

@panagiotisgoulas8539 4 жыл бұрын

Damn functions in sql sux potatoes. It is a pain to call, it is a pain with return value, don't even know why it was not improved over the years. I have to write 3 lines of code to call a procedure...

@011010a 11 жыл бұрын

Thanks Sir

@jimmyd12349 6 жыл бұрын

where can i download that sample database? i wanna use it as practice..

@deepakbhardwaj5432 3 жыл бұрын

Please make on Universal Windows Platform

@secretlives2734 7 жыл бұрын

thanks

@AhmedHassan-qf4in 6 жыл бұрын

how return more than value with output parameters

@kalki1168 Жыл бұрын

How to use this stored procedure in SQL, Anyone please reply

@univuniveral9713 7 жыл бұрын

Please can someone tell me the difference between PRINT and SELECT?

@nikhilal3563 6 жыл бұрын

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)

@shyamprasadatluri7166 4 жыл бұрын

1:07 We haven't created stored procedure before spGetNameById, --------------------------------------------------------------------------------------------------------- Let's create now: -------------------------- Create Procedure spGetNameById @Id int, @Name nvarchar(50) Output AS BEGIN select @Name = Name from tblEmployee where Id = @Id END