how to create a scalar function in sql server

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