COALESCE in SQL Archives -

Difference between ISNULL and COALESCE in SQL

In this article, we will see the difference between ISNULL and COALESCE in SQL Server. Both ISNULL and COALESCE evaluates the expression for NULL and returns a non-null value. ISNULL The ISNULL function replaces NULL with a specified value. ISNULL ( check_expression, replacement_value ) It contains two parameters. The first parameter is to evaluate the… Read More »

MS SQL Server query to return a comma-separated string from a table

In the other article, we saw the usage of Table variables. In this article, we will see how to transform column values in a table to a comma-separated string. Let’s create a table variable “Teams” with the columns ‘ID’ and ‘Team’ (use the below script). When you fire a SELECT over the above table, it… Read More »