Function

What is a Function?

What is a SQL Function and how to use a function in a T-SQL statement? We use the GetDate() and LEFT() functions as examples.


SQL COALESCE Function

The SQL Coalesce function is used when you want to combine values from a series of columns or expressions when they might contain NULL values.