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 th-cam.com/users/kudvenkatplaylists?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. th-cam.com/video/y780MwhY70s/w-d-xo.html If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel. th-cam.com/users/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
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
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.
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.
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....
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 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.
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
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.
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?
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
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?
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 ?
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...
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
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. th-cam.com/video/ETepOVi7Xk8/w-d-xo.html
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".
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
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
Excellent! Thanks for all your videos. You are amazing. Keep up the good work.
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
th-cam.com/users/kudvenkatplaylists?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.
th-cam.com/video/y780MwhY70s/w-d-xo.html
If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel.
th-cam.com/users/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
Thanks Venkat. I will share with my friends. :-)
Thank you so much, Very useful!
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!
Best teacher in the world
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
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.
Thanks for your hardwork..
Really Awesome videos.
For the first time he said, "Can we do that? No, we can not.". He usually says "Absolutely" :)
lol
haha
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
Your peculiarly American compliment probably has Mr Venkat scratching his head. :-)
Why Shit? Shit is s bad word. Pellicore Ji ,please don't use Shit. Use Great.
@@shivarjunroy1394 calling something "the shit" is a compliment meaning it is of the highest quality
Idk how i can thank u man! very appreciate your hard working.
Hi Kudvenkat,
Excellent videos with good explanations for all SQL Server topics. Thanks for helping us with these awesome tutorials.
Best course I came across so far.
Excellent - the best tutorials on SQL that I have seen
I love your videos. And unlike other people you have a large inventory!
This one is very much resourceful, cleared the concept between them. Thank you.
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.
Thank you for all the videos Sir! Every video is simple and easily understandable.
You explain really well! I love your course!!
this man is a legend!
Excellent video teaching sir!!! We pray for your good health !! My Pranams
I learned so much, Thank you Venkat, you are really a good teacher
I mean it sir , you are a master .
Excellent explanations, this is just what I was looking for.
Thanks a lot!
Greetings from Argentina
you are just unbelievably amazing
Hi Venkat, You are really doing a great job...Please keep it up...Thanks for helping us with these awesome tutorials.
YOU ARE MY FAVE EVER!!!!!!!!!!!!!!!
You are the best....Thank You very much Sir
...
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....
Venakt thank you so much you are great
Best till date
Venkat, Stored procedure can return text values as well , if you declare the return type
I wish you made Oracle SQL videos also!!!
Best vedio useful 👏
awesome tutorial .superb presentation .
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
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
Thanks for all videos
just awesome....
Hello @Kudvenkat - Can we get multiple rows using outpur parameter in Stored proc?? Plz answer
In which video you created spGetNameById? Because I looked in the previous and the one before, and sadly didn't found that.
Really Amazing videos Sir!!
good videos. u have all the required content organised. gonna be useful
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.
Thanks Tuomo. I appreciate your response.
GREAT WORK!
Thanks a lot !
Thanks.. thanks.. thanks
Thankyou
Thank you
great
Awesome video.. have you also made video related to normalization ?
Great job. Does anyone has the dataset of this SQL series? Please it will help me a lot.
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
+Parikshith Gari Have you got your answer? Same question here
Hi I got the same doubt. Any update on this? please respond.
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.
usually not always
Thanks Sir
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.
Hi, Could you please help me to understand why output parameters needed when we can get same result using input parameters
Sir, I've used a similar syntax in SQL developer but it caused an error?
Thank you for playing...
After watching this, I can't help wondering why we need return value...
Can Output parameter be of Temp Table or Table Variable data type ?
Can we return a table using stored proecdures?
Please how do I get the output value in my visual studio project?
output paramters are very important than return values
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...
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?
yes it can have more than one output parameters
where can i download that sample database? i wanna use it as practice..
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
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?
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 ?
Please make on Universal Windows Platform
hi hari thae power point presentaion is in his blog you can check it once
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...
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
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.
th-cam.com/video/ETepOVi7Xk8/w-d-xo.html
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".
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
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
Please can someone tell me the difference between PRINT and SELECT?
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)
How to use this stored procedure in SQL, Anyone please reply
how return more than value with output parameters
Use TableValued data type as output parameter.
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
create proc my
as
begin
return 1;
end
declare @id int ;
exec @id =my
select @id
thanks
Please how do I get the output value in my visual studio project?
Please how do I get the output value in my visual studio project?