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
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.
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.
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.
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
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?
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?
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
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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ETepOVi7Xk8.html
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...
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
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
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
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 ?
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....
