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 seminar,................etc; 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...
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.
I have just reached this 19th video now...... 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 part..... Thanks a ton for these videos... Its helping a lot. I will comment on the last video also once I reach it :)
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.
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 :)
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 ones.!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
+Elena Potapchuk Thanks a million for taking time to give feedback. I am glad you found the videos useful. Free Dot Net & SQL Server videos for web developers ruclips.net/user/kudvenkatplaylists?view=1&sort=dd If you need DVDs for offline viewing, you can order them using the link below www.pragimtech.com/Order.aspx Code Samples, Text Version of the videos & PPTS on my blog csharp-video-tutorials.blogspot.com Tips to effectively use our channel ruclips.net/video/y780MwhY70s/видео.html Want to receive email alerts, when new videos are uploaded, please subscribe to our channel using the link below ruclips.net/user/kudvenkat Please click the THUMBS UP button below the video, if you think you liked them Thank you for sharing these links with your friends Best Venkat
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.
Thank you Venkat, teaching technique and the ways are very simple and easily understandable.We get interest as we go from chapter to chapter. Great job :-)
@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 The value from the output parameter(@EmployeeCount) is then received by @TotalCount variable. Execute spGetEmployeeCountByGender @EmployeeCount = @TotalCount out, @Gender = 'Male'
Thank you Venkat for making Store procdure so simple to understand... I can see all of your video's are relating to SQL Development which are great as I had mentioned earlier as well :)) Have you got any video's for SQL Admin also , it will be great if you can suggest any good one , though there are few I found in you tube but I didnt find them very good.. thanks
Hi venkat again gr8 explaination here.Thanks for all what you are doing. I just got a problem hope u help. When i tried to open my sql server 2008 it says:Evaluation period has expired. So anny suggestions plz.
I understand everything you explained so far (great job may I add) but how does the parameter EmployeeCount know to put the output value into the variable TotalCount ?
Hi Venkat. You videos are terrific -- very helpful and understandable. I have to write an application that connects to a SQL Server database and calls stored procedures from it, returning an ADO _RecordsetPtr for the application to use. Can you direct me to a good resource for learning more about how to do that? I am using Visual Studio 2013 VC++ and ADO. Thank you.
Hi Venkat. Thanks for the vidoes. They are much appreciated. What is the advantage of an sp passing the output data to output parameters, as opposed to just returning the output data directly as a result set?
Imp point - When using system stored procedures like "sp_helptext",etc if your user defined stored proc is not in dbo schema , then you will need to use the following syntax ( the square brackets don't work ! ) - EXEC sp_helptext 'SchemaName.stored_proc_name';
Hello Venkat, would you please advise - I am confused with a problem. In below code it seems that after examining IF @enddatetime parameter > 0 the first described action is IF @enddatetime parameter > 0 returns FALSE - and 2nd : ELSE IF @enddatetime parameter > 0 returns TRUE. To my best knowledge IF works in a way that IF TRUE actions always come first, only then ELSE IF FALSE. Please advise if there are real scenarios when this sequence is the opposite? Thanks a lot for your help.
I am sorry to go so much into details but I have not yet found answer in forums e.g. Technet - please advise if I can ask in better way / place. Thanks again.
hi venkat , I actually did noy understand at (11:53) why did you assign @EmployeeCount=@TotalCount. my doubt how @TotalCount get initialized.. plz reply,,
guys a silly question...in queries kudvenkat has lines from where each if starts or ends, or from start to end of a procedure....but i have only lines numbers in my sql server 2008....how can i change so i can see the lines too? the numbers are useful too.
Hi Venkat, I am trying to create a output stored procedure. the syntax is as below. create procedure spGetModelTotal @Type float, @TotlModel int output as begin select @TotlModel= count(ID) from car_sales where type =@Type end I am calling this procedure as below. declare @TotalModel int execute spGetModelTotal 1,@TotalModel out print spGetModelTotal I am getting the below mentioned error. Msg 128, Level 15, State 1, Line 3 The name "spGetModelTotal" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted. Please guide me. Thanks Ankita
can u plz clarify my doubt. I have some fields where people entered names in different cases(lower case n upper case) n i want to insert those fields into my table in single case i.e.lower case. How to do that using stored procedures?
Stored Procedure with output parameter is fine while calling stored procedure from sql server , but while calling stored procedure using edmx how can i get output parameter value ?
Hello Sir, I am facing some issue please help me on that and correct me if i am wrong. I created a Stored Procedure CREATE PROCEDURE spGetAllCustCountbyCuntry @country_name varchar(100) output, @customer_cnt int output as begin SELECT @country_name = Country,@customer_cnt = COUNT(DISTINCT ID) FROM Customer GROUP BY Country ORDER BY Country end When i execute this declare @cnt_name varchar(100) , @cut_cnt int execute spGetAllCustCountbyCuntry @country_name = @cnt_name output ,@customer_cnt = @cut_cnt output select @cnt_name as country_name , @cut_cnt as customer_count; output: country_name customer_count Venezuela 4 I am getting only last record from the table not all the records. Please reply.
Hello Nithin - Not sure what you meant by not displaying fully. I have just checked both of the videos you mentioned and they look fine time. Please let me know what exactly is the problem and I may be able to help you.
![Noob To Max With DRAGON REWORK In Blox Fruits [FULL MOVIE]](http://i.ytimg.com/vi/LnBMOinoOvA/mqdefault.jpg)
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 seminar,................etc; 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...
Black-hearted idiot
I trying to copy your teaching way and techniques
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.
I have just reached this 19th video now...... 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 part..... Thanks a ton for these videos... Its helping a lot. I will comment on the last video also once I reach it :)
You are master of SQL Server ! Thank you for your videos! Great job!
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.
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.
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.
This is simply great Mr Venkat. Your explanations are perfect!
A bundle of thanks. Very good lectures and easy and simplistic way of disseminating knowledge.
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 :)
most professional lectures from this channel on youtube
Thanks a lot Venkat for explaining SQL concepts in easy to understand videos!
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 ones.!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
well thanks allot venkat you are the best tutor i ever found on you tube
hats off to you Venkat, really lovely explanation. thanks a lot for your wonderful videos,
i never learned about stored procedure in my university life.know i understood it very well you are great venkat thankyou very much
what did you study?
if you studied IT and didn't learn about SP's I would ask for my money back.
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!
+Elena Potapchuk Thanks a million for taking time to give feedback. I am glad you found the videos useful.
Free Dot Net & SQL Server videos for web developers
ruclips.net/user/kudvenkatplaylists?view=1&sort=dd
If you need DVDs for offline viewing, you can order them using the link below
www.pragimtech.com/Order.aspx
Code Samples, Text Version of the videos & PPTS on my blog
csharp-video-tutorials.blogspot.com
Tips to effectively use our channel
ruclips.net/video/y780MwhY70s/видео.html
Want to receive email alerts, when new videos are uploaded, please subscribe to our channel using the link below
ruclips.net/user/kudvenkat
Please click the THUMBS UP button below the video, if you think you liked them
Thank you for sharing these links with your friends
Best
Venkat
Venkat Sir, Thanks a lot for the great job you did.👍🙏 You the best.😊😊
Thanks Kud Venkat for this SQL Server Videos - Love your patience with your virtual students.
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.
You are an excellent teacher, GOD bless you
Hello Venkat,
Yet another brilliant performance. Both your "topic selection" and "topic explanation" is really awesome.
Regards,
Anurag
thanks for the clear n concise description...ur a grt teacher
Dear Venkat!Thanks a lot for the great job you did
your videos are just SO GREAT. I feel like it's not fair to watch all for free, is there anywhere to donate?
I think you are totally right. Here you can donate him: www.pragimtech.com/support.aspx
Watch the add until finish? Heard it will give the uploader more?
Yes, of course :-)
Men, you are simply the best !!!!!!!!!!!!!!!!!!!!
Thank you Venkat,
teaching technique and the ways are very simple and easily understandable.We get interest as we go from chapter to chapter.
Great job :-)
hoy bhava kadak video banavlay
@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
The value from the output parameter(@EmployeeCount) is then received by @TotalCount variable.
Execute spGetEmployeeCountByGender @EmployeeCount = @TotalCount out, @Gender = 'Male'
Thank you so much for explaining in clear manner.it is very useful for me
thank you for ur service it is extremely helpful ❣️
Thank you. Great explanation.
The best of youtube !!!!
Loads of love, from Pakistan.
Thank you so much. Your videos are a great help
Very informative video! You explain things really good and is easy to understand :) Thank you
You are a life saver Sir..Thank You..
Wonderful, love your video. Thanks so much!
Awesome 😊 best sql learning videos
Really helpful thanks for explaining all the basic concepts
Thank you Venkat, you helped me out !
you are the best!!
very important when dealing with web applications
Hello Venkat, two words: Excellent and Thanks :-)
Naz
Great presentation.
Thank you. Excellent tutorials.
Thank you Venkat,nice Lecture
Thank you Venkat for making Store procdure so simple to understand... I can see all of your video's are relating to SQL Development which are great as I had mentioned earlier as well :)) Have you got any video's for SQL Admin also , it will be great if you can suggest any good one , though there are few I found in you tube but I didnt find them very good.. thanks
Damn , I'm watching this vid in 2021 and it still beats the competition xD
watching in 2025 and still is very much relevant!
Truly good tutorial...good job
Its very useful for me, Do more videos on sql
Very well explained😊😊
very well explained Venkat
Beats all the SQL Server courses. Relevant even in 2025!
thanks for freshing up my knowledge.
You great!.. Thanks for the slides.
Good Videos Venkat !
Thank You Sir
Very Help full Video..Very Nice Sir
Thanks... It was helpful
I love this video. thanks :)
Thank you all ur SQL videos.. please make detailed video on Teradata
Hi
Hey Venkat sir,
Thank for this video. I really like your way of teaching.
Do you have any video for scrum and JIRA tool?
Thanks
Thank you Sir, Great tutorial
Thank you much for sharing :)
Hi venkat again gr8 explaination here.Thanks for all what you are doing.
I just got a problem hope u help.
When i tried to open my sql server 2008 it says:Evaluation period has expired. So anny suggestions plz.
Does your video help for SQL DBA job,....I means is these videos are enough for DBA job or i have to watch perticular DBA video also
I understand everything you explained so far (great job may I add) but how does the parameter EmployeeCount know to put the output value into the variable TotalCount ?
It was very helpful
Hi Venkat. You videos are terrific -- very helpful and understandable.
I have to write an application that connects to a SQL Server database and calls stored procedures from it, returning an ADO _RecordsetPtr for the application to use. Can you direct me to a good resource for learning more about how to do that? I am using Visual Studio 2013 VC++ and ADO. Thank you.
Hi Venkat. Thanks for the vidoes. They are much appreciated.
What is the advantage of an sp passing the output data to output parameters, as opposed to just returning the output data directly as a result set?
6iiiiyio9yi
Hkkmvk
Imp point - When using system stored procedures like "sp_helptext",etc
if your user defined stored proc is not in dbo schema , then you will need to use the following syntax ( the square brackets don't work ! ) -
EXEC sp_helptext 'SchemaName.stored_proc_name';
sir please do a video on how to give identity property only using stored procedure without giving identity property in table
Very detailed explanation
very very good！
great tutorial!!!
simply Good.
Hello Venkat,
would you please advise - I am confused with a problem.
In below code it seems that after examining IF @enddatetime parameter > 0 the first described action is
IF @enddatetime parameter > 0 returns FALSE -
and 2nd : ELSE IF @enddatetime parameter > 0 returns TRUE.
To my best knowledge IF works in a way that IF TRUE actions always come first, only then ELSE IF FALSE.
Please advise if there are real scenarios when this sequence is the opposite?
Thanks a lot for your help.
great tutorial :)
Thanks a lot sir.. thanks
Just awesome
I am sorry to go so much into details but I have not yet found answer in forums e.g. Technet - please advise if I can ask in better way / place.
Thanks again.
Hi venkat, how to implement stored procedures output parameters in VB.NET ? Can we use the output keyword in VB.Net ?
outstanding!
hi venkat , I actually did noy understand at (11:53) why did you assign @EmployeeCount=@TotalCount. my doubt how @TotalCount get initialized.. plz reply,,
Thanks a lot .....
superb explanations
Hi venkant sir from. Where can we get the practice file which you are using
guys a silly question...in queries kudvenkat has lines from where each if starts or ends, or from start to end of a procedure....but i have only lines numbers in my sql server 2008....how can i change so i can see the lines too? the numbers are useful too.
thank you!!!
the best.
thank you sir.
Where want to download this database and proceed to code ?
Great !
DO you have tutorial for function, and trigger creation as well ? Please Help ! thanks
Hi Venkat,
I am trying to create a output stored procedure. the syntax is as below.
create procedure spGetModelTotal
@Type float,
@TotlModel int output
as
begin
select @TotlModel= count(ID)
from car_sales
where type =@Type
end
I am calling this procedure as below.
declare @TotalModel int
execute spGetModelTotal 1,@TotalModel out
print spGetModelTotal
I am getting the below mentioned error.
Msg 128, Level 15, State 1, Line 3
The name "spGetModelTotal" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.
Please guide me.
Thanks
Ankita
Instead of "print spGetModelTotal" you should use "print @TotalModel", because you want to print the value of the variable, not the procedure.
CEUBE89 thanks a lot. it worked.
can u plz clarify my doubt.
I have some fields where people entered names in different cases(lower case n upper case) n i want to insert those fields into my table in single case i.e.lower case. How to do that using stored procedures?
Stored Procedure with output parameter is fine while calling stored procedure from sql server , but while calling stored procedure using edmx how can i get output parameter value ?
sgdhftarthakss shah HGTmmy
Thanks
Hello Sir,
I am facing some issue please help me on that and correct me if i am wrong.
I created a Stored Procedure
CREATE PROCEDURE spGetAllCustCountbyCuntry
@country_name varchar(100) output,
@customer_cnt int output
as
begin
SELECT @country_name = Country,@customer_cnt = COUNT(DISTINCT ID)
FROM Customer
GROUP BY Country
ORDER BY Country
end
When i execute this
declare @cnt_name varchar(100) , @cut_cnt int
execute spGetAllCustCountbyCuntry @country_name = @cnt_name output ,@customer_cnt = @cut_cnt output
select @cnt_name as country_name , @cut_cnt as customer_count;
output:
country_name customer_count
Venezuela 4
I am getting only last record from the table not all the records.
Please reply.
Someone Notice that,
We are using the ( = ) operator for "assignment" and also for "equality" checking.
Hi venkat your part 18 part 19 videos about stored procedure are not displaying fully can you pls reupload it
Hello Nithin - Not sure what you meant by not displaying fully. I have just checked both of the videos you mentioned and they look fine time. Please let me know what exactly is the problem and I may be able to help you.