creating scalar function in sql

SQL Server allows us to create our functions called as user defined functions in SQL Server.