How to create our own functions - T-SQL Step by Step Course - Lesson 24 | SQL courses

Duration: 19:32 min

Summary: Today, we are continuing our discussion on functions. In the previous video, I discussed scalar-valued functions. With today’s discussion we will see how to create our own functions. We will create a function that returns the full address base on an ID passed as a parameter. We will start with the basic structure of the function and modify that to satisfy our needs. After we are done, we will discuss the different ways this function can be called. We will also see how to drop the function and recreate it.