Scalar user defined functions in sql server Part 30

In this video we will learn about
1. User Defined Functions in sql server
2. Types of User Defined Functions
3. Creating a Scalar User Defined Function
4. Calling a Scalar User Defined Function
5. Places where we can use Scalar User Defined Function
6. Altering and Dropping a User Defined Function

Text version of the video

Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our YouTube channel. Hope you can help.

Slides

All SQL Server Text Articles

All SQL Server Slides

All Dot Net and SQL Server Tutorials in English

All Dot Net and SQL Server Tutorials in Arabic

[wasimbader]

THANK YOU SIR, I HOPE U DO FULL TUT ON SAS/SPSS OR DATA ANALYSIS WITH FEW PROGRAMS

[ouruzbekhomeschool]

11 years later, and yet still benefiting from his lessons immensely. Thank you a lot!

[gawiga]

Your indian accent is so cool.
Thank you for give this knowledge for free. Greetings from Brazil.

[lizravenwood]

I am so in love with your teaching! I cannot believe how brilliant you are with all of these different technologies as well as the ability and willingness to teach and share. Thank you so much. Namaste.

[anuragvashishtha]

I will recommend these videos to every SQL Server student. Thanks a lot Venkat.

[amantlemashele]

You have been improving my coding since 2015, from C# to MVC to SQL

[mdasadujjaman]

12 years later, and still benefiting from his lessons immensely. Thanks a lot Sir.!

[tksafi]

thanks man your sql videos are the best on youtube

[devikasiddani]

Hi Venkat, All your videos are simple and clear which makes anyone easy to understand, your tutorials are like a Gift, Thank you so much.

[QuietLumina]

This is so incredibly clear and helpful. Thank you so much!

[prabdeepdhaliwal]

So I was trying to create the CalculateAge() function myself and display the table with Name, DOB and Age before you showed us how to. I got the age values that were 10 years higher than your values and was confused on what I did wrong. Then I remembered the video is like 10 years old so all those people aged by 10 😂

[yamaya]

Watching you in 2022. Your teaching style is very easy to grasp. God bless!

[rgarayia]

Hi Venkat, Want to thank you for your wonderful videos. They are simply great!!

[Csharp-video-tutorialsBlogspot]

Hi zainzoom,

To invoke a scalar function prefix dbo. before the name of the function. For example, if you have order with Id=101, then invoke the function as shown below.
Select dbo.GetTotalOrderValue(201), SomeOtherColumn
from SomeTable
where SomeCondition

I hope this will resolve your issue. If not let me know.

[mdfaysal]

Thank you Sir for a nice tutorial. All of your tutorials are so much easy to understand for every level of learners.

[hongshen]

Thank you  Kudvenkat so much for creating this series of SQL training videos for beginners. They are so easy to understand with the tables and query demonstrations.  You are very good at teaching. I learn a few videos each day and decide to finish them all.  Again, many thanks.
Do you teach Python? Hope you have some videos too.

[gracechan]

In Korea that actually count you as 1 year old as soon as you are born, so Koreans didn't need to add the case statement. haha.
Seriously though, thanks for these videos. They help me so much with my job.

[dbin]

another clear and concise explanation. thanks for this.

[nerellapydiraju]

Very helpful videos for beginners, Thank you very much

[maheshgore]

Great session...very informative and complete