SQL Server scalar-valued function takes one or more parameters and returns a single value. The scalar functions help you simplify your code. For example, you may have a complex calculation that ...

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.[Function Name]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT')) ...