Creating And Using Functions in MS SQL - With Examples!!

In this video I have created two functions. One returns a scalar value and another returns a table. The scalar function adds two numbers where as the table valued one returns a table after splitting a string. In the end I dropped both these functions in a different ways to demonstrates various ways of deleting a function. I have tried to keep the language as simple as possible. Hope you like the video. :)

[jonathanjordan]

sir, does this only works for Microsoft DBMS?

bcs i cannot use it on MYSQL Benchmark

[SteveoStories]

I appreciate the effort but you make a ton of mistakes that can be just edited out.. thanks for the vid

[daalwada]

Hi, you told that the values 'a, b, c, d', ', ' will be separated by commas, but in the result it does not show comma. I think you mean, wherever the comma appears, it splits the character and then shows as a separate row value, isn't it?

[mttwss]

Your private message feature is not set up in the 'about' area of your channel.

[Afalaa]

Great video, but your camera is bit far away from ssms.

[anitapanigrahi]

We cannot use the scalar function in update statement? I need something on that.

[GooseGumlizzard]

my created function is nowhere to be found in the functions folder, why?

[unknownad_official]

can we call a function without ceating it?

[AshriLucky]

Getting erroe as Invalid Object String_Split

[pleabargain]

What application are you using? Which v. of SQL?

[sakijilan]

sorry you really have to get the kinks out of your programming skills, before making another video.