Functions in SQL

Functions are a very important topic in SQL, and they are used almost everywhere in our queries. In this blog, I will explain the concept of functions and its pre-defined types available to us.

What is a function ?

Stored piece of program that manipulates submitted data and return some value. A function is a set of SQL statements that perform a specific task. Instead of rewriting the SQL query again and again, we can simply call that function. A function accepts inputs in the form of parameters and returns a value.

SQL Server comes with a set of built-in functions that perform a variety of tasks.